In: Accounting
Shadee Corp. expects to sell 520 sun visors in May and 430 in June. Each visor sells for $20. Shadee’s beginning and ending finished goods inventories for May are 70 and 60 units, respectively. Ending finished goods inventory for June will be 60 units. 1. Determine Shadee's budgeted total sales for May and June. 2. Determine Shadee's budgeted production in units for May and June.
|
1 | Budgeted Total Sale | ||
May | June | ||
A | Budgeted Sale Units | 520 | 430 |
B | Selling Price Per Unit | 20 | 20 |
A*B=C | Budgeted Total Sale | 10400 | 8600 |
2 | Budgeted Production Units | ||
A | Opening FG Inventory Units | 70 | 60 |
B | Closing FG Inventory Units | 60 | 60 |
C | Budgeted Sales Units | 520 | 430 |
C+B-A | Budgeted Production Units | 510 | 430 |
Part-2
1 | Closure Cost of Purchase | ||
May | June | ||
A | Opening Inventory of Closure | 26 | 16 |
B | Closing Inventory of Closure | 16 | 22 |
C | Closure Used in Production (From Part 2 Above) | 510 | 430 |
C+B-A=D | Closure Purchased | 500 | 436 |
E | Cost Per Closure | 2.5 | 2.5 |
D*E | Cost of Closure Purchased | 1250 | 1090 |
2 | Budgeted Manufacturing Overhead | ||
May | June | ||
A | Fixed Manuafacturing | 1500 | 1500 |
B | Variable Manufacturing Overhead (1.25* Production) | 637.5 | 537.5 |
C | Budgeted Manufacturing Overhead | 2137.5 | 2037.5 |
Part-3
1 | Budgeted Direct Labor Cost | ||
May | June | ||
A | Direct Labor Cost (0.4 Hour*11 Per Hour*Production) | 2332 | 1804 |
(0.4*11*510) (0.4*11*430) |
Part-4
Budgeted Manufacturing Cost per visor | Unit Sold | May | June | |
Direct Material | 4.5 | *520 May,*430 June | 2340 | 1935 |
Direct Labor 0.4*11 | 4.4 | *520 May,*430 June | 2288 | 1892 |
Variable Overhead | 1.25 | *520 May,*430 June | 650 | 537.5 |
Fixed Overhead | 1.9 | *520 May,*430 June | 988 | 817 |
Total Manufacturing Cost per visor | 12.05 | 6266 | 5181.5 |