Excel File Home Paste H16 AutoSave 13 14 15 16 17 18 19 20 21 Edit View I- Insert Draw Page Layout Calibri (Body) BI U V Insert V 2. C- 12 Enter Answer Format Tools Data Window Direct labor rate per hour Markup charged on jobs *** Formulas • Α' Α' A- au Data Review View == Budgeted MOH costs at start of year Budgeted direct labor hours at start of year Estimated hours for new client's job Update Available We've made some fixes and improvements. To complete the process, the app needs to restart. x✓ fx Help A B 1 Formulas: Multiply, Add, Divide; Cell Referencing 2 3 BE8.12-Using Excel to Determine Job Cost and Bid Price for a Service 4 Company 5 PROBLEM 6 Jace and Associates provides professional consulting services to a variety of 7 clientele in an effort to help them improve the operating effectiveness and 8 profitability of their businesses. The company's accountant established 9 budgeted direct labor hours as its allocation base. The company is 10 considering doing work for a new client. Information concerning the job for 11 the new client is presented here. 12 Automate Acrobat Tell me 2 $ $ 250,000 100,000 V 45 30.00 D ExcelAssignmentChapter8 Question2- 60% Accounting $% 9 DE F 58 08 Cell Conditional Format Formatting as Table Styles G Insert Delete Format H $ 28-0. Sort & Find & Filter Select Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Determine the budgeted MOH rate, the cost of the job, and how much should Jace bid on this job. Budgeted MOH rate Cost of job Bid on job 2.50 Per DL hour 1,462.50 Sens
Excel File Home Paste H16 AutoSave 13 14 15 16 17 18 19 20 21 Edit View I- Insert Draw Page Layout Calibri (Body) BI U V Insert V 2. C- 12 Enter Answer Format Tools Data Window Direct labor rate per hour Markup charged on jobs *** Formulas • Α' Α' A- au Data Review View == Budgeted MOH costs at start of year Budgeted direct labor hours at start of year Estimated hours for new client's job Update Available We've made some fixes and improvements. To complete the process, the app needs to restart. x✓ fx Help A B 1 Formulas: Multiply, Add, Divide; Cell Referencing 2 3 BE8.12-Using Excel to Determine Job Cost and Bid Price for a Service 4 Company 5 PROBLEM 6 Jace and Associates provides professional consulting services to a variety of 7 clientele in an effort to help them improve the operating effectiveness and 8 profitability of their businesses. The company's accountant established 9 budgeted direct labor hours as its allocation base. The company is 10 considering doing work for a new client. Information concerning the job for 11 the new client is presented here. 12 Automate Acrobat Tell me 2 $ $ 250,000 100,000 V 45 30.00 D ExcelAssignmentChapter8 Question2- 60% Accounting $% 9 DE F 58 08 Cell Conditional Format Formatting as Table Styles G Insert Delete Format H $ 28-0. Sort & Find & Filter Select Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Determine the budgeted MOH rate, the cost of the job, and how much should Jace bid on this job. Budgeted MOH rate Cost of job Bid on job 2.50 Per DL hour 1,462.50 Sens
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Concept explainers
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Question
Transcribed Image Text:Excel File Edit View Insert Format Tools Data
.. AutoSaveB2-C-
Home Insert Draw Page Layout
-
n
Paste
H16
X
12
13
Calibri (Body)
B I U .
14
14
15
16
17
18
19
20
21
33
Ready
HY
B
A
B
1 Formulas: Multiply, Add, Divide; Cell Referencing
2
12
Direct labor rate per hour
Markup charged on jobs
Enter Answer
+
Accessibility: Investigate
Formulas
LEOO
tab
***
A A
& A
✓
Update Available We've made some fixes and improvements. To complete the process, the app needs to restart.
x ✓ fx
Budgeted MOH costs at start of year
Budgeted direct labor hours at start of year
Estimated hours for new client's job
esc
BE8.12-Using Excel to Determine Job Cost and Bid Price for a Service
4 Company
5
PROBLEM
6 Jace and Associates provides professional consulting services to a variety of
7 clientele in an effort to help them improve the operating effectiveness and
8 profitability of their businesses. The company's accountant established
9 budgeted direct labor hours as its allocation base. The company is
10 considering doing work for a new client. Information concerning the job for
11 the new client is presented here.
12
!
Data Review
1
==
Q
A
Window Help
N
2
W
View
H
S
C
$
Automate Acrobat Tell me
28- Accounting
$ 250,000
100,000
#3
OCT
15
V
45
30.00
60%
D
E
D ExcelAssignment Chapter8_Question2
D
$%9
$
E
4
X C
F
R
♫ON latv
v
F
Conditional Format Cell
Formatting as Table Styles
Student Work Area
Required: Provide input into cells shaded in yellow in this template. Input the
required mathematical formulas or functions with cell references to the Problem
area or work area as indicated.
Budgeted MOH rate
Cost of job
Bid on job
67 20
Determine the budgeted MOH rate, the cost of the job, and how much should
Jace bid on this job.
5
G
T
+
ZA
MacBook Pro
^
6.
G
Y
V B
$
$
&
Insert v
Delete
Format v
7
H
H
1,462.50
2.50 Per DL hour
se
U
24-O-
Sort & Find &
Filter Select
P
00
UTRGV Fall 2021 GSCM 3310-9-
Import/Export C
8
N
200m
J
GSCM 4310-
Forecasting
(
)
9
I
J
0
ܗ.
K
0
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education