Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hey, hope you are doing well. I need help for 6,7,8,9,10,11,12 and 13 please. I have already got the answer to 1,2,3,4, and 5. thank

image text in transcribed

image text in transcribed

image text in transcribed

Hey, hope you are doing well. I need help for 6,7,8,9,10,11,12 and 13 please. I have already got the answer to 1,2,3,4, and 5. thank you for that.

PREPARATION OF OPERATING AND FINANCIAL BUDGETS Happy Baker produces banana bread for resale at large grocery stores throughout Australia. The company is currently in the process of establishing a master budget on a quarterly basis for the next financial year, which ends June 30. Last year quarterly sales were as follows (1 unit = 1 batch): First quarter 50,AAA units Second quarter 75,BBB units Third quarter 86,CCC units Fourth quarter 90, DDD units See further instructions about last year quarterly sales figures in the table below: ID Number First Name Last Name Group Member No. 1. NXX2037 Mouse Mickey Donald 2. APS2094 Duck 3. EMV30216 Bear Yogi Scooby 4. AEES2104 Doo First quarter 50,AAA units becomes 50,037 units. AAA is the last three digits of Member 1's ID. Second quarter 75,BBB units becomes 75,094 units. BBB is the last three digits of Member 2s ID. Third quarter 86,CCC units becomes 86,216 units. CCC is the last three digits of Member 3's ID. Fourth quarter 90, DDD units become 90,104 units. DDD is the last three digits of Member 4's ID. PREPARATION OF OPERATING AND FINANCIAL BUDGETS (Continued) Unit sales are expected to increase 25 percent, and each unit is expected to sell for $15. The management prefers to maintain ending finished goods inventory equal to 20 percent of next quarter's sales. Assume finished goods inventory at the end of the fourth quarter budget period is estimated to be 20,000 units. Direct Materials Purchases Budget Information Each unit of product requires 1.75 pounds of direct materials per unit, and the cost of direct materials is $1.5 per pound. Management prefers to maintain ending raw materials inventory equal to 30 percent of next quarter's materials needed in production. Assume raw materials inventory at the end of the fourth quarter budget periodis estimated to be 55,000 pounds. Direct Labor Budget Information Each unit of product requires 0.20 direct labor hours at a cost of $15 per hour. Manufacturing Overhead Budget Information Variable overhead costs are: Indirect materials $0.10 per unit Indirect labor $0.15 per unit Other $0.10 per unit Fixed overhead costs each quarter are: Salaries $32,000 Rent $20,000 Depreciation $16,165 Happy Baker estimates that all selling and administrative costs are fixed. Quarterly selling and administrative cost estimates for the coming year are: Salaries $40,000 Rent $ 5,000 Advertising $10,000 Depreciation $ 8,000 Other $ 1,000 All direct materials purchases are on credit. The company expects to pay 80 percent of purchases in the quarter of purchase and 20 percent the following quarter. Accounts payable balance at the end of last year was $50,000, all of which will be paid in the first quarter of this coming year. The cash balance at the end of last year was $35,000. The company does not have an overdraft facility with their bank. Assume Happy Baker will collect 25 percent of fourth quarter budgeted sales in full next year (this represents accounts receivable at the end of the fourth quarter). The following account balances are expected at the end of the fourth quarter: Property, plant, and equipment (net): $320,000 Ordinary Shares: $1,000,000 Retained earnings at the end of last year amounted to $1,234,000.00 and no cash dividends are anticipated for the budgetperiod ending June 30. Required: With the information provided, assist Happy Baker in setting up their 'Master Budget'. To do this, you will need to prepare the following budgets for coming year: 1. Sales Budget 2. Production Budget 3. Direct Materials Purchases Budget 4. Direct Labour Budget 5. Manufacturing Overhead Budget 6. Ending Finished Goods Inventory Budget 7. Selling & Administration Expenses Budget 8. Expected Cash Collections 9. Expected Cash Disbursements for Materials 10. Cash Budget 11. Budgeted Income Statement 12. Budgeted Balance Sheet* 13. Review the cash budget for Happy Baker. Comment on the company's cash position in the coming year, and provide one recommendation to resolve one issue you have raised

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Communication In The Age Of Trump

Authors: Arthur S. Hayes

1st Edition

1433150301, 9781433150302

More Books

Students also viewed these Accounting questions

Question

2. Write the introduction section of a paper.

Answered: 1 week ago