Question

Question:

e) Overhead budget (4 marks) f) Selling and administrative expenses budget (4 marks)

Materials

Fizzy Pop bottles a lemon flavoured soft drink. All inventory is in direct materials and finished goods at the end of each qu

Assignment continued . Packaging - each case is packed in a cardboard carton (one carton per case). Each carton costs $0.80.

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Estimated Production units
Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total for 2021
Units sold        260,000          240,000          280,000           300,000     1,080,000
Add: ending finished goods inventory        135,000          135,000          135,000           135,000         135,000
Units available for sale        395,000          375,000          415,000           435,000     1,215,000
Less: Beginning finished goods inventory        100,000          135,000          135,000           135,000         100,000
Units Produced        295,000          240,000          280,000           300,000     1,115,000
Units Produced        295,000          240,000          280,000           300,000
Multiply: Direct labor hour per unit               0.02                 0.02                 0.02                  0.02
Direct labor hours required (DLH)            5,900               4,800               5,600                6,000
Overhead budget
Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total for 2021
Direct labor hours required (DLH)            5,900               4,800               5,600                6,000
Indirect materials $4,425 $3,600 $4,200 $4,500 $16,725
Electricity $11,800 $9,600 $11,200 $12,000 $44,600
Maintenance on machine $2,950 $2,400 $2,800 $3,000 $11,150
Supervisor's salary (Fixed cost) $72,000 $72,000 $72,000 $72,000 $288,000
Factory rent (Fixed cost) $85,000 $85,000 $85,000 $85,000 $340,000
Insurance (Fixed cost) $14,000 $14,000 $14,000 $14,000 $56,000
Machinery depreciation (Fixed cost) $16,000 $16,000 $16,000 $16,000 $64,000
Total overhead $206,175 $202,600 $205,200 $206,500 $820,475
Selling and administration budget
Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total for 2021
Units sold        260,000          240,000          280,000           300,000
Freight and delivery costs $1,040,000 $960,000 $1,120,000 $1,200,000 $4,320,000
Advertising costs $20,000 $20,000 $20,000 $20,000 $80,000
Office salaries $40,000 $40,000 $40,000 $40,000 $160,000
Rent on Admin. building $25,000 $25,000 $25,000 $25,000 $100,000
Insurance expenses $5,000 $5,000 $5,000 $5,000 $20,000
Depreciation on office expense $5,000 $5,000 $5,000 $5,000 $20,000
Total selling and administration $1,135,000 $1,055,000 $1,215,000 $1,295,000 $4,700,000
Add a comment
Know the answer?
Add Answer to:
Question: Materials e) Overhead budget (4 marks) f) Selling and administrative expenses budget (4 marks) Fizzy...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • question 1 material c) Direct materials purchases budget (9 marks) Fizzy Pop bottles a lemon flavoured...

    question 1 material c) Direct materials purchases budget (9 marks) Fizzy Pop bottles a lemon flavoured soft drink. All inventory is in direct materials and finished goods at the end of each quarter. There is no work-in-process inventory. Fizzy Pop uses cases as the unit of analysis in its budgeting. Each case contains 24 bottles. The business is preparing to build its master budget for the next financial year ending 31 December 2021. The master budget will be based on...

  • Question Material g) Ending finished goods inventory budget (3 marks) h) Cost of goods sold budget...

    Question Material g) Ending finished goods inventory budget (3 marks) h) Cost of goods sold budget (4 marks) Fizzy Pop bottles a lemon flavoured soft drink. All inventory is in direct materials and finished goods at the end of each quarter. There is no work-in-process inventory. Fizzy Pop uses cases as the unit of analysis in its budgeting. Each case contains 24 bottles. The business is preparing to build its master budget for the next financial year ending 31 December...

  • 40. Selling and Administrative Budget and Budgeted Income Statement. CThe previous problem must b...

    PREVIOUS PROBLEM! 40. Selling and Administrative Budget and Budgeted Income Statement. CThe previous problem must be completed before working this problem.) Sports Bars, Inc., produces energy bars. Management estimates all selling and administrative costs are fixed. Quarterly selling and administrative cost estimates for the coming year follow Salaries Rent Advertising $120,000 Depreciation 75,000 Other $170,000 $ 65,000 36,000 Required: a Use the information presented previously to prepare a selling and administrative budget. Refer to the format shown in Figure 9.8....

  • Need Selling & Administrative Expense Budget, Cash Budget, Budgeted Income Statement for EXCEL. Schedules to include:...

    Need Selling & Administrative Expense Budget, Cash Budget, Budgeted Income Statement for EXCEL. Schedules to include: a. Sales Budget, with a Schedule of Expected Cash Collections b. Production Budget c. Ending Finished Goods Inventory Budget d. Direct Materials Budget, with a Schedule of Cash Disbursement e. Direct Labor Budget f. Manufacturing Overhead Budget g. Selling & Administrative Expense Budget h. Cash Budget i Budgeted Income Statement Sharp Products is a manufacturing company. It uses absorption costing for budgeting. amount unit...

  • repare the selling and administrative expense budget. WILDHORSE FARM SUPPLY COMPANY Selling and Administrative Expense...

    repare the selling and administrative expense budget. WILDHORSE FARM SUPPLY COMPANY Selling and Administrative Expense Budget For the Six Months Ending June 30, 2020 V Quarter Six Months Sales 28400 42600 71000 Variable Expenses 259860 649650 389790 176000 649650 176000 X Fixed Expenses 176000 176000 Total Selling and Administrative Expenses v 435860 $ 565790 825650 Click if you would like to Show Work for this question: Open Show Work Question 5 Wildhorse Farm Supply Company manufactures and sells a pesticide...

  • Create These budgets: -selling and administrative expense budget -cash budget include a schedule of cash collections...

    Create These budgets: -selling and administrative expense budget -cash budget include a schedule of cash collections and payments -finished goods inventory calculation Then, Create the following schedules, financial statements, and calculations A) Pro forma cost of goods manufactured B) Pro forma Cost of goods sold- both financial and variable cost basis C) Pro forma income statement (financial basis) D) Pro forma balance sheet E)Pro forma Income statement (variable cost basis) F) Pro forma statement of retained earnings G) breakeven analysis:...

  • 39. Budgeting for Sales, Production, Direct Materials, Direct Labor, and Manufacturing Overhead. ...

    NEED ANSWER OF THE " F " PART ONLY! 39. Budgeting for Sales, Production, Direct Materials, Direct Labor, and Manufacturing Overhead. Sports Bars Inc., produces energy bars and sells them by the case (1 unit - 1 case). Information to be used for the operating budget this coming year follows: Average sales price for each case is estimated to be $25. Unit sales for this coming year, ending December 31, are expected to be as follows First quarter 80,ooo Second...

  • Okay Company is preparing to build its master budget. The budget will detail each quarter's activity and the activity for the year in total.

    Master Budget ProjectOkay Company is preparing to build its master budget. The budget will detail each quarter's activity and the activity for the year in total. The master budget will be based on the following information:a. This will be the first year of operation for Okay Company.b. Budgeted unit sales by quarter for 2017 are projected as follows: First quarter 6,300 , Second quarter 6,100 , Third quarter 6,100 & Fourth quarter 6,450 . First and second quarter 2018 budgeted...

  • preparing a master budget practice Schedules to include: a. Sales Budget, with a Schedule of Expected Cash Coll...

    preparing a master budget practice Schedules to include: a. Sales Budget, with a Schedule of Expected Cash Collections b. Production Budget C. Ending Finished Goods Inventory Budget d. Direct Materials Budget, with a Schedule of Cash Disbursement e. Direct Labor Budget f. Manufacturing Overhead Budget g. Selling & Administrative Expense Budget h. Cash Budget i. Budgeted Income Statement Sharp Products is a manufacturing company. It uses absorption costing for budgeting. amount unit Budgeted sales: Q1 of 2019 23,000 cases Q2...

  • Sales (500,000 units) Costs and expenses Direct materials Direct labor Overhead Selling expenses Administrative expenses Total...

    Sales (500,000 units) Costs and expenses Direct materials Direct labor Overhead Selling expenses Administrative expenses Total costs and expenses Net income $7,500.888 1,000,000 2,000,000 see,eee 750.800 1,285.cee 5.535.000 $1,965,000 The company has an opportunity to sell 50,000 additional units at $13 per unit. The additional sales would not affect its current expected sales. Direct materials and labor costs per unit would be the same for the additional units as they are for the regular units. However, the additional volume would...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT