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