In: Accounting
Shadee Corp. expects to sell 640 sun visors in May and 430 in June. Each visor sells for $17. Shadee’s beginning and ending finished goods inventories for May are 75 and 55 units, respectively. Ending finished goods inventory for June will be 70 units.
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 33 closures on hand on May 1, 18 closures on May 31, and 23 closures on June 30. Additionally, Shadee’s fixed manufacturing overhead is $1,000 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.
2. Determine Shadee's budget manufacturing overhead for May and June.
-----------------------------------------------------------------------------------------------------------
Suppose that each visor takes 0.10 direct labor hours to produce and Shadee pays its workers $6 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.)
--------------------------------------------------------------------------------------------------------------
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 33 closures on hand on May 1, 18 closures on May 31, and 23 closures on June 30 and variable manufacturing overhead is $2.00 per unit produced. Suppose that each visor takes 0.10 direct labor hours to produce and Shadee pays its workers $6 per hour.
Required:
1. Determine Shadee’s budgeted manufacturing cost per visor. (Note: Assume that fixed overhead per unit is $3.)
2. Compute the Shadee’s budgeted cost of goods sold for May and June.
-----------------------------------------------------------------------------------------------------------------------------------------
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 33 closures on hand on May 1, 18 closures on May 31, and 23 closures on June 30. Additionally, Shadee’s fixed manufacturing overhead is $1,000 per month, and variable manufacturing overhead is $2.00 per unit produced. Each visor takes 0.10 direct labor hours to produce and Shadee pays its workers $6 per hour.
Additional information:
Required:
Determine Shadee's budgeted selling and administrative expenses for May and June. (Do not round your intermediate calculations. Round your answers to 2 decimal places.)
---------------------------------------------------------------------------------------------------------------------------------------
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 33 closures on hand on May 1, 18 closures on May 31, and 23 closures on June 30 and variable manufacturing overhead is $2.00 per unit produced. Suppose that each visor takes 0.10 direct labor hours to produce and Shadee pays its workers $6 per hour.
Additional information:
Required:
Complete Shadee's budgeted income statement for the months of May and June. (Note: Assume that fixed overhead per unit is $3.00.) (Do not round your intermediate calculations. Round your answers to 2 decimal places.)
1.
Purchases Budget : Closures | ||
May | June | |
Budgeted Production in Units | 620 | 445 |
Add: Desired Ending Inventory of Closures | 18 | 23 |
Total closures needed | 638 | 468 |
Less: Beginning Inventory | 33 | 18 |
Budgeted purchases of closures in units | 605 | 450 |
Cost of closures per unit | $ 2 | $ 2 |
Budgeted Cost of Closures Purchased | $ 1,210 | $ 900 |
2.
Production Budget | ||
May | June | |
Budgeted Sales in Units | 640 | 430 |
Add: Desired Ending Inventory | 55 | 70 |
Total Finished Inventory Needed | 695 | 500 |
Less: Beginning Inventory | 75 | 55 |
Budgeted Production in Units | 620 | 445 |
3.
Manufacturing Overhead Budget | ||
May | June | |
Budgeted Production in Units | 620 | 445 |
Variable Overhead per Unit | $ 2 | $ 2 |
Total Variable Overhead | $ 1,240 | $ 890 |
Fixed Overhead per Month | 1,000 | 1,000 |
Budgeted Manufacturing Overhead | $ 2,240 | $ 1,890 |
4.
Direct Labor Budget | ||
May | June | |
Budgeted Production in Units | 620 | 445 |
Direct Labor Hours Needed | 62 | 44.5 |
Direct Labor Hour Rate | $ 6 | $ 6 |
Budgeted Direct Labor Cost | $ 372 | $ 267 |
5.
Direct Materials | $ 5.50 |
Direct Labor Cost | 0.60 |
Variable Manufacturing Overhead | 2.00 |
Fixed Overhead | 3.00 |
Total Manufacturing Cost per unit | $ 11.10 |
6.
May | June | |
Budgeted Sales in Units | 640 | 430 |
Manufacturing Cost per Unit | $ 11.10 | $ 11.10 |
Budgeted Cost of Goods Sold | $ 7,104 | $ 4,773 |
7.
May | June | |
Selling Costs ( Sales x 8 % ) | $ 870.40 | $ 584.80 |
Administrative Expenses | 1,400 | 1,400 |
Budgeted Selling and Administrative Expenses | $ 2,270.40 | $ 1,984.80 |
8.
Budgeted Income Statement | ||
May | June | |
Budgeted Sales | $ 10,880 | $ 7,310 |
Budgeted Cost of Goods Sold | (7,104) | (4,773) |
Gross Profit | 3,776 | 2,537 |
Budgeted Selling and Administrative Expenses | (2,270.40) | (1,984.80 ) |
Budgeted Net Operating Income | $ 1,505.60 | $ 552.20 |