You are an accountant working for a local accounting firm based in Ballina. You have been assigned a new client, Ice Blox!, the company behind Flyin' Fox ice blox (a boutique, family owned ethical business who hand craft award winning ice blox's in Murwillumbah).

Benna and her husband John launched their ice blocks back in 2009. Originally from the UK, they were in awe of the top quality fruit available here in Australia and identified a gap in the market for a range of quality ice blocks. At the forefront of the small batch, artisan ice block movement Flyin' Fox ice blox have reinterpreted the Australian ice block tradition.

They have requested for you to make a master budget for Flyin' Fox ice blox for 2021 which allows them to plan, work through "what if" scenarios and help them to make informed decisions to ensure their business continues to operate successfully into the future, particularly considering the impact of COVID-19 on the Australian economic circumstances in 2020.

The following information has been gathered about their business: ?

• Operations:Flyin' Fox ice blox operate on a calender-year basis. The business runs out of owned premises in Mullumbimby. Their sales team have provided the expected quarterly sales per carton of ice block. Each carton has 20 ice blocks. ?
• Plant and Equipment:Depreciation on the Plant and equipment totals $10,000 per quarter. ?
• Cash collections:The company expects to collect 80% of its credit sales in the quarter of sale and the remaining 20% of credit sales will be collected in the quarter after sales. The company's bad debts are negligible. ?
• Payments:The company plans to pay for 50% of its material purchases within the quarter of purchase and the remaining 50% in the following quarter. ?
• Ignore GST and Income Tax. ?
• All of the budget assumptions have been provided to you in a budget template ready for you to use to make the Master Budgets. Below are some screenshots of these assumptions.

BUDGET ASSUMPTIONS

All 4 Quarters Quarters Sales Budget 1 2 3 4

Budgeted sales in cartons 10,000 8,000 5,000 9,000

Selling price per carton $ 65.00

Percentage of sales collected in the quarter of sale 80%

Percentage of sales collected in the quarter after sale 20%

Production Budget

Percentage of next quarters sales in ending finished goods inventory 20%

Direct Materials Budget

Kilos of fruit per carton 15

Cost per Kilo of fruit $ 1 .20

Percentage of next quarter's production needs in ending inventory 15%

Percentage of purchases paid in the quarter purchased 50%

Percentage of purchases paid in the quarter after purchase 50%

Direct Labour Budget

Direct labour-hours required per carton 0.8

Direct labour cost her hour $ 25.84

Manufacturing Overhead Budget

Variable manufacturing overhead per direct labour-hour $ 4.00

Fixed manufacturing overhead per quarter $ 60,600.00

Depreciation per quarter $ 15,000.00

Selling and Administrative Expense Budget

Variable Selling and administrative expense per carton $ 1.80

Fixed selling and administrative expense per quarter:

Advertising $ 20,000.00

Owners Salaries $ 50,000.00

Insurance $ 10,000.00

Property Tax $ 4,000.00

Depreciation $ 10,000.00

Cash Budget

Minimum cash balance $ 30,000.00

Equipment purchases $10,000.00 $ 2,500.00 $ 5,000.00 $5,000.00

Interest rate per quarter (simple interest only not compound) 9%

Balance Sheet, December 31, 2020

Current Assets

Cash $22,500.00

Accounts Receivable $50,000.00

Raw materials inventory (21 000 kg) $ 4,200.00

Finished Goods inventory (2 000 cartons) $26,000.00 ______________

Total Current Assets $102,700.00

Plant and Equipment

Land $80,000.00

Buildings $700,000.00

Accumulated Depreciation ($292,000.00) _________________

Plant and Equipment, Net $488,000.00

$590,700.00

Total Assets

Current Liabilities

Accounts payable $25,800.00

Retained Earnings $564,900.00

Total Liabilities $590,700.00

Budget Assumptions ice BOX Balance Sheet, December 31, 2020 Current Assets Cash 22,500.00 Accounts Receivable 50,000.00 Raw materials inventory (21 000 kg) 4 200.00 Finished Goods inventory (2 000 cartons) 26,000.00 Total Current Assets $ 102,700.00 Plant and Equipment Land 80,000.00 Buildings $ 700,000.00 Accumulated Depreciation ($292,000.00) Plant and Equipment, Net $ 488,000.00 $ 590,700.00 Total Assets Current Liabilities Accounts payable 25,800.00 Retained Earnings 5 564,900.00 Total Liabilities $ 590,700.00X Budget Assumptions ICE VOX All 4 Quarters Quarters Sales Budget 1 4 Budgeted sales in cartons 10,000 8,000 5.000 9.000 Selling price per carton 65.00 Percentage of sales collected in the quarter of sale Percentage of sales collected in the quarter after sale 20% Production Budget Percentage of next quarters sales in ending finished goods inventory Direct Materials Budget Kilos of fruit per carton 15 Cost per Kilo of fruit 1.20 Percentage of next quarter's production needs in ending inventory 15% Percentage of purchases paid in the quarter purchased Percentage of purchases paid in the quarter after purchase 50% Direct Labour Budget Direct labour-hours required per carton 0.8 Direct labour cost her hour 25.84 Manufacturing Overhead Budget Variable manufacturing overhead per direct labour-hour 4.00 Fixed manufacturing overhead per quarter 60,600100 Depreciation per quarter 13.000.00 Selling and Administrative Expense Budget Variable selling and administrative expense per carton 180 Fixed selling and administrative expense per quarter: Advertising 20,000 00 Owners Salaries 50.000.00 Insurance 10.000.00 Property Tox 4.000.00 Depreciation 10,000.00 Cath Budget Minimum cash balance 30,000.00 Equipment purchases $ 10,000.00 $ 2,500.00 $ 5,000.00 $ 5,000.00 Interest rate per quarter (simple interest only not compound)