Question

Help Save & E Chec NuFloor Manufacturing produces floor tiles. The managers at NuFloor are trying to develop budgets for the upcoming quarter. The following data have been gathered for a particular tile design. Projected unit sales Selling price per case Inventory at the beginning of the quarter Target inventory at the end of the quarter Direct labor hours needed to produce one case Direct labor wages Direct material cost per case Variable manufacturing overhead cost per case Fixed overhead costs for the upcoming quarter 1,450 cases $ 240 150 cases 100 cases 2 hours 10 per hour $ 8 $ 6 $220,000 $ a. Using this information, develop NuFloor's sales forecast in dollars and its schedule of production in units. b. What is NuFloor's budgeted variable manufacturing cost per case? c. Prepare NuFloor's manufacturing cost budget. d. What is the projected ending inventory value for this particular tile design? Complete this question by entering your answers in the tabs below.

Answer 1

Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks!

NuFloor
Answer a	Amount $	Note
Budgeted sales (Units)	1,450.00	A
Sell price	240.00	B
Budgeted sales ($)	348,000.00	C=A*B
Production Budget	Units
Budgeted sales (Units)	1,450.00	See A
Add: Closing	100.00	D
Less: Opening	150.00	E
Production Budget	1,400.00	F=A+D-E
Answer b	Amount $
Labor hour per case	2.00	G
Labor cost per hour	10.00	H
Labor cost per case	20.00	I=G*H
Direct Material per case	8.00	J
Variable manufacturing overhead per case	6.00	K
Variable manufacturing cost per case	34.00	L=I+J+K
Answer c	Amount $
Production Budget	1,400.00	See F
Variable manufacturing cost per case	34.00	See L
Total Variable manufacturing cost	47,600.00	M=F*L
Add: Fixed manufacturing cost	220,000.00	N
Total Cost of goods manufactured	267,600.00	O=M+N
Units produced	1,400.00	See F
Manufacturing Cost per unit	191.14	P=O/F
Answer d	Amount $
Ending finished goods inventory	100.00	See D
Manufacturing Cost per unit	191.14	See P
Cost of ending finished goods inventory	19,114.00	Q=D*P