In: Accounting
Shadee Corp. expects to sell 600 sun visors in May and 350 in June. Each visor sells for $22. Shadee’s beginning and ending finished goods inventories for May are 65 and 40 units, respectively. Ending finished goods inventory for June will be 55 units.
E8-6 Preparing Raw Materials Purchases and Manufacturing Overhead Budgets [LO 8-3c, e]
Each visor requires a total of $5.50 in direct materials that
includes an adjustable closure that the company purchases from a
supplier at a cost of $2.00 each. Shadee wants to have 29 closures
on hand on May 1, 20 closures on May 31, and 26 closures on June
30. Additionally, Shadee’s fixed manufacturing overhead is $1,400
per month, and variable manufacturing overhead is $2.00 per unit
produced.
Required:
1. Determine Shadee's budgeted cost of closures
purchased for May and June. (Round your answers to 2
decimal places.)
2. Determine Shadee's budget manufacturing
overhead for May and June. (Do not round your intermediate
values. Round your answers to 2 decimal places.)
Suppose that each visor takes 0.80 direct labor hours to produce
and Shadee pays its workers $7 per hour.
Required:
Determine Shadee's budgeted direct labor cost for May and June.
(Do not round your intermediate values. Round your answers
to 2 decimal places.)
Statement Showing Production Budget | |||
May | June | Total | |
Sales | 600 | 350 | 950 |
Desired Ending inventory | 40 | 55 | 55 |
Total Unit Needed | 640 | 405 | 1005 |
Less: Beg. Inventory | 65 | 40 | 65 |
Production required | 575 | 365 | 940 |
Statement Showing Budgeted Cost material Purchase | |||
May | June | Total | |
Production unit | 575 | 365 | 940 |
RM Required /Visor ( $5.50/$2)=2.75 | 1581.25 | 1003.75 | 2585 |
Ending Raw Material | 20 | 26 | 26 |
Total Raw material Required | 1601.25 | 1029.75 | 2611 |
Less: Opening Inventory | 29 | 20 | 29 |
Purchase Quantity Required | 1572.25 | 1009.75 | 2582 |
Purchase Cost /Pound | $2 | $2.00 | $2.00 |
Total Purchase Cost | $3,145 | $2,020 | $5,164 |
Statement Showing Manufacturing Overhead Budget | |||
May | June | Total | |
Unit Produced | 575 | 365 | 940 |
Variable Manufacturing Overhead/Unit | $2.00 | $2.00 | 2 |
Total Variable Manufacturing Overhead (a) | $1,150.00 | $730.00 | $1,880.00 |
Fixed Manufacturing Overhead (b) | $1,400.00 | $1,400.00 | $2,800.00 |
Total Manufacturing Overhead Cost (a+b) | $2,550.00 | $2,130.00 | $4,680.00 |
Statement Showing Direct Labour Cost Budget | |||
May | June | Total | |
Unit Produced | 575 | 365 | 940 |
Direct Labour Require/Unit | 0.8 | 0.8 | 0.8 |
Total Labour Hour require (a) | 460 | 292 | 752 |
Rate /Hour(b) | $7 | $7 | $7 |
Total Labour Cost (a*b) | $3,220 | $2,044 | $5,264 |