Morgan Inc predicts sales of 4,000 frames in May 14,000 units in June Target end of month finished goods inventory is 10 of next months sales The company wants RM ending inventory to cover 20 of next months needs The frames each require 2 pieces of trim to manufacture and each trim costs $3 per piece The frames also require three hours of labor The direct labor rate is $10 per hour What is the target number of units (frames) in ending finished goods inventory for may What was Beginning Finished Goods Inventory (frames) in units for May Prepare a production budget for frames for May What is the total units (frames) to produce in May Prepare a production budget for frames for May What is the total units (frames) to produce in May If Junes budgeted production 6,000 frames What is the desired inventory of Raw Materials (trim not frames) at the end of May What was the beginning raw materials inventory for May (trim not frames) Prepare a May materials usage budget for Morgan Inc if Junes budgeted production 6,000 frames How many pieces of trim must be purchased in May Prepare a May materials usage budget for Morgan Inc if Junes budgeted production 6,000 frames What is the total budgeted Raw Materials Cost for May Give your answer in dollars as a positive number but do not use the $ sign Hint be sure you differentiate between frames (completed product) and pieces of trim (raw material) Prepare a direct labor budget in hours and dollars for May What is the total budgeted direct labor cost for May for Morgan Inc Give your answer as a positive number (no sign)

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 13, 2024

Morgan Inc. predicts sales of 4,000 frames in May & 14,000 units in June. Target end of month finished-goods inventory is 10% of next months

Morgan Inc. predicts sales of 4,000 frames in May & 14,000 units in June.

Target end of month finished-goods inventory is 10% of next months sales.

The company wants RM ending inventory to cover 20% of next months needs.

The frames each require 2 pieces of trim to manufacture and each trim costs $3 per piece. The frames also require three hours of labor. The direct labor rate is $10 per hour

What is the target number of units (frames) in ending finished goods inventory for may?
What was Beginning Finished Goods Inventory (frames) in units for May?
Prepare a production budget for frames for May. What is the total units (frames) to produce in May?
Prepare a production budget for frames for May. What is the total units (frames) to produce in May?
If Junes budgeted production = 6,000 frames. What is the desired inventory of Raw Materials (trim not frames) at the end of May?
What was the beginning raw materials inventory for May (trim not frames)?
Prepare a May materials usage budget for Morgan Inc. if Junes budgeted production = 6,000 frames. How many pieces of trim must be purchased in May
Prepare a May materials usage budget for Morgan Inc. if Junes budgeted production = 6,000 frames. What is the total budgeted Raw Materials Cost for May? Give your answer in dollars as a positive number but do not use the $ sign. Hint: be sure you differentiate between frames (completed product) and pieces of trim (raw material).
Prepare a direct labor budget in hours and dollars for May. What is the total budgeted direct labor cost for May for Morgan Inc.? Give your answer as a positive number (no sign).