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