Question: I need help developing a manufacturing budget using an Excel spreadsheet Projected Sales Budget 2019 Quarter 2 10,000 3 4 1 Year Expected Unit Sales

I need help developing a manufacturing budget using an Excel spreadsheet

I need help developing a manufacturing budget using an Excel spreadsheet Projected

Sales Budget 2019 Quarter 2 10,000 3 4 1 Year Expected Unit

Sales 8,000 65.00 S65.00 S65.00 S70.00 8,000 2000 38,000 Total Sales Additional

Projected Sales Budget 2019 Quarter 2 10,000 3 4 1 Year Expected Unit Sales 8,000 65.00 S65.00 S65.00 S70.00 8,000 2000 38,000 Total Sales Additional information for the Production Budget: 1 Beginning Finished Goods Inventory in units for Q1 2019 is 500 units 2 Each quarter's Finished Goods Inventory should contain 10% of the following quarter's Expected Units Sales 3 Estimated Q1 2020 Expected Unit Sales are projected to be 5,000 Projected SG&A Expense Budget 2019 Quarter 2 10,000 3 4 12,000 S 38,000 Year Budgeted Unit Sales Variable Cost 8,000 8,000 Sales Commissions ($3.40/unit) S 27,200 S 34000 S 27,200 40,800 S 129,200 Freight-out (S1.10/unit) S 8.800 S 11,000S 8,800 13.200 S 41,800 S 36,000 45,000 36,000 54,000 171,000 S 5,000 $5,000 S 5,000 $ 5,000 S 20,000 S 7,500 S 7,500 S 7,500 $ 7,500 S 30,000 Total variable cost Fixed Cost Advertising Sales Salaries Office Salaries Depreciation Property Taxes and Insurance 1500 S1500 S 1500 S1500 S6,000 S 15,000 $ 15,000 15,000 $ 15,000 S 60,000 S 1,000 $ 1,000 S 1,000 $ 1,000 S 4,000 $ 30,00030,000 30,000 $30,000 120,000 Total fixed cost Total SG&A S 66,000 75,000 66,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!