Question

In: Accounting

Direct Materials Budget For the year ending December 31, 2018 Plain t-shirts Q1 Q2 Q3 Q4...

Direct Materials Budget
For the year ending December 31, 2018
Plain t-shirts Q1 Q2 Q3 Q4 Total
Units to be produced 1060 1260 1600 2000 5920
Direct materials per unit 1 1 1 1 1
Production needs 1060 1260 1600 2000 5920
Desired ending inventory 126 160 200 106 106
Total needs 1186 1420 1800 2106 6026
Less beginning inventory 58 126 160 200 58
Direct materials to be purchased 1128 1294 1640 1906 5968
Cost per t-shirt $       3.00 $       3.00 $       3.00 $       3.00 $       3.00
Total t-shirt purchase cost $ 3384 3882 4920 5718 17904
Ink: Q1 Q2 Q3 Q4 Total
Units to be produced 1060 1260 1600 2000 5920
Direct materials per unit 5 5 5 5 5
Production needs 5300 6300 8000 10000 29600
Desired ending inventory 630 800 1000 530 530
Total needs 5930 7100 9000 10530 30130
Less beginning inventory 390 630 800 1000 390
Direct materials to be purchased 5540 6470 8200 9530 29740
Cost per ounce $       0.20 $       0.20 $       0.20 $       0.20 $       0.20
Total ink purchase cost $ 1108 1294 1640 1906 5948
Total cost of all direct materials $ 4492 5176 6560 7624 23852
Direct Labor Budget
For the year ending December 31, 2018
Q1 Q2 Q3 Q4 Total
Units to be produced 1060 1260 1600 2000 5920
Direct labor hours per unit 0.12 0.12 0.12 0.12 0.12
Production needs 127.20 151.20 192.00 240.00 710.40
Wage cost per hour $          10 $          10 $          10 $          10 $          10
Total direct labor cost $ 1272 1512 1920 2400 7104

The overhead budget shows forecasted variable and fixed overhead costs for the coming year.  For Texas Rex the variable overhead rate is $5 per direct labor hour.  Fixed overhead is budgeted at $1645 per quarter.

Overhead BudgetFor the year ending December 31, 2018

                                                Q1                    Q2                    Q3                    Q4                    Total

Budgeted Direct Labor hours

Variable Overhead Rate             _______           _______           ________         ________       _______

Budgeted Variable Overhead     

Budgeted Fixed Overhead         _______           _______           ________         _______       ________

Total Overhead Cost

Calculate the Total Unit Cost:

                Direct Materials

                Direct Labor

                Overhead                 

                Total Unit Cost

Solutions

Expert Solution



Related Solutions

Do all the Q1, Q2, Q3 and Q4 The cash budget is the primary tool used...
Do all the Q1, Q2, Q3 and Q4 The cash budget is the primary tool used in short-term financial planning. As with many calculations, the sales forecast is a primary input. As an example of the cash budgeting process, we will use the Fun Toys Corporation. The sales projections and other information provided are: Q1 Q2 Q3 Q4 Sales $    200,000,000 $      300,000,000 $    250,000,000 $    400,000,000 Beginning receivables: $    120,000,000 Receivables period (days):                        45 With the receivables period shown, we can calculate the percentage...
Production Budget Q1 Q2 Q3 Q4 Total Sales in Units        1,000        1,200        1,500...
Production Budget Q1 Q2 Q3 Q4 Total Sales in Units        1,000        1,200        1,500        2,000        5,700 Add: Desired Ending Inv.                240            300            400            400            400 Total Needs        1,240        1,500        1,900        2,400        6,100 Less:Beginning Inv.                180            240            300            400            180 Units to be produced        1,060        1,260        1,600        2,000        5,92 The Direct Materials Budget tells management how much...
Brunell Products has projected the following sales for the coming year:    Q1 Q2 Q3 Q4...
Brunell Products has projected the following sales for the coming year:    Q1 Q2 Q3 Q4 Sales $480 $570 $720 $660    Sales in the year following this one are projected to be 10 percent greater in each quarter.    Calculate payments to suppliers assuming that the company places orders during each quarter equal to 25 percent of projected sales for the next quarter. Assume that the company pays immediately.    a. What is the payables period in this case?...
Wentworth Products has projected the following sales for the coming year: Q1 Q2 Q3 Q4   Sales...
Wentworth Products has projected the following sales for the coming year: Q1 Q2 Q3 Q4   Sales $360 $450 $600 $540 Sales in the year following this one are projected to be 10 percent greater in each quarter. Calculate payments to suppliers assuming that the company places orders during each quarter equal to 25 percent of projected sales for the next quarter. Assume that the company pays immediately. a. What is the payables period in this case? (Do not round intermediate...
Wentworth Products has projected the following sales for the coming year: Q1 Q2 Q3 Q4   Sales...
Wentworth Products has projected the following sales for the coming year: Q1 Q2 Q3 Q4   Sales $650 $740 $875 $805 Sales in the year following this one are projected to be 15 percent greater in each quarter. a. Assume that the company places orders during each quarter equal to 30 percent of projected sales for the next quarter. Assuming that the company pays immediately, what is the payables period? (Do not round intermediate calculations and round your answer to the...
All That Remains Products has projected sales for next year of: Q1 Q2 Q3 Q4 Sales...
All That Remains Products has projected sales for next year of: Q1 Q2 Q3 Q4 Sales $ 76,000 $ 79,775 $ 86,500 $ 93,480 The company places orders each quarter that are 52 percent of the following quarter's sales and has a 60-day payables period. What is the accounts payable balance at the end of the third quarter?
The following annual budget data relates to Navient Inc. for the year ending December 31, 2018....
The following annual budget data relates to Navient Inc. for the year ending December 31, 2018.                                         Item APP Item ZAP Sales budget: Anticipated volume in units 400,000 250,000 Unit selling price $23.00 $29.00 Production budget: Desired ending finished goods units 27,000 20,000 Beginning finished goods units 34,000 11,000 Direct materials budget: Direct materials per unit (pounds) 3 4 Desired ending direct materials pounds 35,000 16,000 Beginning direct materials pounds 43,000 12,000 Cost per pound $4.00 $5.00 Direct labor budget:...
The following annual budget data relates to Navient Inc. for the year ending December 31, 2018....
The following annual budget data relates to Navient Inc. for the year ending December 31, 2018.                                         Item APP Item ZAP Sales budget: Anticipated volume in units 400,000 250,000 Unit selling price $23.00 $29.00 Production budget: Desired ending finished goods units 27,000 20,000 Beginning finished goods units 34,000 11,000 Direct materials budget: Direct materials per unit (pounds) 3 4 Desired ending direct materials pounds 35,000 16,000 Beginning direct materials pounds 43,000 12,000 Cost per pound $4.00 $5.00 Direct labor budget:...
Let Q1, Q2, Q3, Q4 be constants so that R (2x + 3) sin 4x dx...
Let Q1, Q2, Q3, Q4 be constants so that R (2x + 3) sin 4x dx = (Q1x + Q2) sin 4x + (Q3x+Q4) cos 4x+C, where C is a constant of integration. Let Q = ln(3 +|Q1|+ 2|Q2|+ 3|Q3| + 4|Q4|). Then T = 5 sin2 (100Q) satisfies:— (A) 0 ≤ T < 1. — (B) 1 ≤ T < 2. — (C) 2 ≤ T < 3. — (D) 3 ≤ T < 4. — (E) 4 ≤...
First Last Q0 Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 L0 L1 L2 L3...
First Last Q0 Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 L0 L1 L2 L3 L4 L5 L6 L7 L8 L9 P0 P1 P2 E0 E1 E2 FI ATT ------------------------------------------------------------------------------------------------------------------------------------------ Kevin Smith 90 100 100 100 98 97 87 100 85 87 89 100 100 100 100 90 100 98 90 100 98 98 98 90 90 98 88 0.00 Morgan Kelly 80 100 65 67 69 71 100 100 100 67 95 85 87 89 100 65 67...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT