stuueplayeHomeworkas pxthomeworkid 4442077028questionld-18flushed-false8cld 4637
ID: 2577196 • Letter: S
Question
stuueplayeHomeworkas pxthomeworkid 4442077028questionld-18flushed-false8cld 4637407&icenterwi; Managerial Accounting F17 Homework: P9-57A Score: 0 of 5 pts P9-57A (similar to) Devon Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Devon Manufacturing's operations 10t 1 (o complete) (Click the icon to view the data) (Click the icon to view additional data.) Data Table Current Assets as of December 31 (prior year) 4.600 S 49,000 15,300 S 121,500 $ 43,000 S 127,000 S 23,000 Cash Accounts receivable, net Inventory Property, plant, and equipment, net Accounts payable Capital stock Retained earnings PrintDone 12 pertaining Clear AllExplanation / Answer
1
January
February
March
Total sales
99600
118800
115200
Credit Sales at 65%
64740
77220
74880
Cash Sales at 35%
34860
41580
40320
Schedule of cash payments
January
February
March
Quarter
Cash Sales at 35%
34860
41580
40320
116760
Credit sales (collected in next month)
46150
27027
26208
99385
81010
68607
66528
216145
Jan credit sales 71000*65%
2
Production Budget
January
February
March
Quarter
Total sales
99600
118800
115200
Unit selling price
12
12
12
Unit sales
8300
9900
9600
27800
Plus: Desired ending inventory
990
960
900
2850
Less: Beginning Inventory
830
990
960
2780
Number of units to produce
8460
9870
9540
27870
(108000/12)*0.10 = 900
3
Direct Materials Budget:
January
February
March
Quarter
Units to be produced
8460
9870
9540
27870
Quantity of direct material needed per unit
x 3
x 3
x 3
x 3
Quantity needed for production
25380
29610
28620
83610
Plus: Desired ending inventory
5922
5724
5376
17022
Less: Desired opening inventory
5076
5922
5724
16722
Quantity to be purchased
26226
29412
28272
83910
cost per pound
2
2
2
2
Total cost for Direct Material purchases
52452
58824
56544
167820
4
Cash payaments for direct Materials Budget
Purchases
January
February
March
Quarter
December
43000
43000
January
10490
41961.6
52451.6
Febraury
11764.8
47059.2
58824
March
11308.2
Total cash payments
53490
53726.4
58367.4
154275.6
5
Direct Labor Budget
January
February
March
Quarter
Number of units to produce
8460
9870
9540
27870
Direct labor hour per unit
0.05
0.05
0.05
0.05
Direct labor hour rate per unit
9
9
9
9
3807
4441.5
4293
12541.5
6
Manufacturing budget
February
March
Quarter
Variable Moh
9306
10857
10494
30657
Rent
5500
5500
5500
16500
Other Fixed MOH
2900
2900
2900
8700
Cash payments for MOH
17706
19257
18894
55857
7
cash payments for operating expenses budget
January
February
March
Quarter
Variable operating budget
10375
12375
12000
34750
Fixed operating budget
1800
1800
1800
5400
cash payments for operating expenses budget
12175
14175
13800
40150
1
January
February
March
Total sales
99600
118800
115200
Credit Sales at 65%
64740
77220
74880
Cash Sales at 35%
34860
41580
40320
Schedule of cash payments
January
February
March
Quarter
Cash Sales at 35%
34860
41580
40320
116760
Credit sales (collected in next month)
46150
27027
26208
99385
81010
68607
66528
216145
Jan credit sales 71000*65%
2
Production Budget
January
February
March
Quarter
Total sales
99600
118800
115200
Unit selling price
12
12
12
Unit sales
8300
9900
9600
27800
Plus: Desired ending inventory
990
960
900
2850
Less: Beginning Inventory
830
990
960
2780
Number of units to produce
8460
9870
9540
27870
(108000/12)*0.10 = 900
3
Direct Materials Budget:
January
February
March
Quarter
Units to be produced
8460
9870
9540
27870
Quantity of direct material needed per unit
x 3
x 3
x 3
x 3
Quantity needed for production
25380
29610
28620
83610
Plus: Desired ending inventory
5922
5724
5376
17022
Less: Desired opening inventory
5076
5922
5724
16722
Quantity to be purchased
26226
29412
28272
83910
cost per pound
2
2
2
2
Total cost for Direct Material purchases
52452
58824
56544
167820
4
Cash payaments for direct Materials Budget
Purchases
January
February
March
Quarter
December
43000
43000
January
10490
41961.6
52451.6
Febraury
11764.8
47059.2
58824
March
11308.2
Total cash payments
53490
53726.4
58367.4
154275.6
5
Direct Labor Budget
January
February
March
Quarter
Number of units to produce
8460
9870
9540
27870
Direct labor hour per unit
0.05
0.05
0.05
0.05
Direct labor hour rate per unit
9
9
9
9
3807
4441.5
4293
12541.5
6
Manufacturing budget
February
March
Quarter
Variable Moh
9306
10857
10494
30657
Rent
5500
5500
5500
16500
Other Fixed MOH
2900
2900
2900
8700
Cash payments for MOH
17706
19257
18894
55857
7
cash payments for operating expenses budget
January
February
March
Quarter
Variable operating budget
10375
12375
12000
34750
Fixed operating budget
1800
1800
1800
5400
cash payments for operating expenses budget
12175
14175
13800
40150
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.