15 16 A. 17 18 c D EMPLOYEES: (one each) Supervisor Measurer fuses the pencil and ruler Cutter (uses the scissors) Assembler (uses the glue) The following production estimates were made for the coming year: Total quilts to be produced 20,000 2,000 Total manufacturing hours available per laborer Total direct laborers Total direct labor hours 6,000 The following cost estimates were available at the beginning of the year 22 Use these estimates to determine total estimated manufacturing overhead during the year: 23 Amount Estimate for Year $ 1,000 $ $2,000.00 Production supervisor's salary per week fuse 52 weeks in a year) Monthly rent 676 8.112.00 Utilities expense per quarter 676 2,704.00 Cost per pencil (useful life of each pencil is 20 hours) 2 200.00 119 2,975.00 Cost per scissors (useful life of each pair of scissors is 80 hours) Cost per ruler (usefule life of each ruler is 50 hours) 62 2,480.00 Cost of glue (per quilt) 0.62 12,400.00 Total Estimated Manufacturing Overhead $ 80.871.00 Calculate the predetermined Overhead (PDOH) rate using direct labor hours (DLH) as the cost driver during the year to allocate manufacturing overhead to jobs and Work In Process Inventory: POOH-5 Complete the following job cost sheet for the WVU themed quilts Job Cost Sheet Direct Materials Sheets Cost per Sheet 16 $ || 29 || 24 — Hours Rate per Hr. 0.40 $ 0.40 0.40 1.20 13.48 Answer the following questions: ▶ Instructions 19 20 21 62 0. Ready White material Blue material Yellow material Measuring labo Cutting labor Assembly labor Total Manufacturing Overhead $ Total Job Cost Number of Quilts Made Cost per Quilt + Direct Labor E Predetermined CH Rate AM4 Project F G H Total 2.00 $ 32.00 4.00 116.00 4.00 96.00 $ 244.00 Total 14.00 $ 5.60 12.00 4.80 16.00 6.40 $ 16.80 DUI Used Total L M N MANUFACTURING SIMULATION: WVU Bookstore Special Order (Actual results) Sheets of material used Number of quits made White Yellow: Blue: #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 13.48 per DU 15 #N/A 0 #N/A #N/A #N/A #N/A #N/A QR $ T U V W X Y Z AAABACACACAFAG AH AI AJ 用 D AK AL AM AN 75% A
15 16 A. 17 18 c D EMPLOYEES: (one each) Supervisor Measurer fuses the pencil and ruler Cutter (uses the scissors) Assembler (uses the glue) The following production estimates were made for the coming year: Total quilts to be produced 20,000 2,000 Total manufacturing hours available per laborer Total direct laborers Total direct labor hours 6,000 The following cost estimates were available at the beginning of the year 22 Use these estimates to determine total estimated manufacturing overhead during the year: 23 Amount Estimate for Year $ 1,000 $ $2,000.00 Production supervisor's salary per week fuse 52 weeks in a year) Monthly rent 676 8.112.00 Utilities expense per quarter 676 2,704.00 Cost per pencil (useful life of each pencil is 20 hours) 2 200.00 119 2,975.00 Cost per scissors (useful life of each pair of scissors is 80 hours) Cost per ruler (usefule life of each ruler is 50 hours) 62 2,480.00 Cost of glue (per quilt) 0.62 12,400.00 Total Estimated Manufacturing Overhead $ 80.871.00 Calculate the predetermined Overhead (PDOH) rate using direct labor hours (DLH) as the cost driver during the year to allocate manufacturing overhead to jobs and Work In Process Inventory: POOH-5 Complete the following job cost sheet for the WVU themed quilts Job Cost Sheet Direct Materials Sheets Cost per Sheet 16 $ || 29 || 24 — Hours Rate per Hr. 0.40 $ 0.40 0.40 1.20 13.48 Answer the following questions: ▶ Instructions 19 20 21 62 0. Ready White material Blue material Yellow material Measuring labo Cutting labor Assembly labor Total Manufacturing Overhead $ Total Job Cost Number of Quilts Made Cost per Quilt + Direct Labor E Predetermined CH Rate AM4 Project F G H Total 2.00 $ 32.00 4.00 116.00 4.00 96.00 $ 244.00 Total 14.00 $ 5.60 12.00 4.80 16.00 6.40 $ 16.80 DUI Used Total L M N MANUFACTURING SIMULATION: WVU Bookstore Special Order (Actual results) Sheets of material used Number of quits made White Yellow: Blue: #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 13.48 per DU 15 #N/A 0 #N/A #N/A #N/A #N/A #N/A QR $ T U V W X Y Z AAABACACACAFAG AH AI AJ 用 D AK AL AM AN 75% A
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter16: Manufacturing Accounting (mfg)
Section: Chapter Questions
Problem 2R
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
I need help with the empy yellow boxes in c please
Transcribed Image Text:AutoSave OFF
Home Insert
X
Paste
J47
A
D 2 - C
Draw Page Layout
Calibri (Body)
V
10
B
I
U
B
Formulas Data
Α' Α΄
V
A.
V
F
Direct Labor
V
fx
C
D
3
4
5
EMPLOYEES: (one each)
Supervisor
Measurer
(uses the pencil and ruler)
Cutter
(uses the scissors)
9
Assembler
(uses the glue)
10
11
12
13
14
15
16 A.
The following production estimates were made for the coming year:
17
Total quilts to be produced
20,000
18
Total manufacturing hours available per laborer
2,000
19
Total direct laborers
3
20
Total direct labor hours
6,000
21
The following cost estimates were available at the beginning of the year.
22
Use these estimates to determine total estimated manufacturing overhead during the year:
23
Amount Estimate for Year
24
$ 1,000 $
52,000.00
Production supervisor's salary per week (use 52 weeks in a year)
Monthly rent
25
676
8,112.00
26
Utilities expense per quarter
676
2,704.00
27
Cost per pencil (useful life of each pencil is 20 hours)
2
200.00
28
119
2,975.00
Cost per scissors (useful life of each pair of scissors is 80 hours)
Cost per ruler (usefule life of each ruler is 50 hours)
29
62
2,480.00
30
Cost of glue (per quilt)
0.62
12,400.00
31
Total Estimated Manufacturing Overhead
$
80,871.00
32
33 B.
Calculate the Predetermined Overhead (PDOH) rate using direct labor hours (DLH) as the cost driver during the year to allocate manufacturing
overhead to jobs and Work In Process Inventory:
34
35
PDOH= $
36
37 C.
Complete the following job cost sheet for the WVU themed quilts:
38
Job Cost Sheet
39
Direct Materials
40
Sheets
Cost per Sheet
Total
41
White material
16
$
2.00 $ 32.00
42
Blue material
29
4.00
116.00
96.00
43
Yellow material
24
4.00
44
$ 244.00
45
46
47
Hours Rate per Hr.
Total
48
Measuring labor
0.40 $
14.00 $ 5.60
49
0.40
12.00
4.80
50
Cutting labor
Assembly labor
Total
0.40
16.00
6.40
51
1.20
Ś 16.80
52
53
Manufacturing Overhead
54
Total
55
$
13.48
56
57
Total Job Cost
58
Number of Quilts Made
Cost per Quilt
59
60
61
62 D.
Answer the following questions:
63
If you decide to charge the bookstore cast plue 10% for the quilte the calling n ce for one quilt is:
Instructions
M4 Project
Ready
E
Predetermined OH Rate
G
Review
H
DLH Used
ab
View
ab
Wrap Text v
Merge & Center ✓
K
L
M
WVU Bookstore Special Order (Actual results)
Number of quilts made:
16
24
29
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
MANUFACTURING SIMULATION:
Sheets of material used:
White:
Yellow:
Blue:
Tell me
13.48 per DLH
M4 P (4)
General
$
N
#N/A
15
V
% 9
O
#N/A
#N/A
#N/A
#N/A
#N/A
P
.00
✈0
Q
V
Conditional Format
Formatting as Table
R
S
T
Cell
Styles
U
Insert
Delete
V W X Y Z AAABACADAEAFAG AH
88
Σ
↓
Format
AI
B
1.1.9
AJ
>
I
Share
Or
Find &
Sort &
Filter Select
AK
AL
AM
Comments
Analyze
Data
AN
75%
AO
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 2 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
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning