Cash receipt	April	May	June	Total
Retail sales
Event sales
Vegan society (100L)
Corporate event
Total receipts
Cash disbursement	April	May	June	Total
DM costs
DL costs
MOH costs
Social media activities
Total disbursement
Cash balance	April	May	June	Total
Net cash
Opening Cash balance
Ending Cash balance

The Information provided in 3 sheets:

Sheet 1:

Sheet 2:

Sheet 3:

THE END.

Product name Report type Wakeup Juice (WUJU) Standard Unit costs (STD_UC) Direct Cost of 1 liter WUJU 6. Direct materials Avocado flesh (kg) Banana flesh (kg) Baby Spinach (kg) Coconut water Total DM Amount in recipe Unit price of ingrdient Standard costs 0. 0.92 0.1 3 0.375 0.05) 9 0.45 0.51 2 2.75 Direct labour 2 staff Total DL per 1000ml DL hours/month Rate ($/hr) 352 Labour cost per month 20 7040.00 4.32 Direct cost per 1000ml 7.07 Per month Manufacturing overhead Utilities (electricity+gas+water) Depreciation of blender Rent Insurance MOH per 100ml Allocation 300 output 21.65 output 3000 output 14 output Qty of allocation Cost per 1000ml 1630 0.181 1630 0.01 1630 1.84 1630 0.01 2.05 Per 1000 ml Medium (340ml) 9.11 Source: Production costs Paper Cup Standard cost each product Budgeted selling price 3.10 0.095 3.19 8.00 Per day/blender (1) Per month per blender Number of blender Total capacity Maximum capacity 50 1100 2 2200 Budgeted sales and production per month Estimated event sale (liters) Estimated retail sales (units) Total estimated sales (liters) Estimated output per month (litres) Blender cost ($) Fridge Expected useful life (years) Per month depreciation Rent Insurance per year Total fixed MOH per month Variable MOH per month MOH per liter 100 4500 1630 1630 998 1600 10 21.65 3000 168 3035.65 300 2.05 Assumptions Avocado Banana 65% % of flesh/whole fruit 80% Product name Standard cost per liter Wakeup Juice (WUJU) 9.11 Direct materials Avocado flesh (kg) Banana flesh (kg) Baby Spinach (kg) Coconut water (1) Unit price of Amount in recipe ingrdient ($) 0.1 6 0.1 3 0.05 9 0.5 2 COO Average weight (gr) % of flesh Flesh Avocado Banana 170 118 65% 80% 110.5 94.4 FORECAST FOR the second quarter of 2021 (From April to Jun) Sales Event sales (liters) Retail sales (unit) April 150 5000 May 200 4800 June 100 4500 Price ($) 15 7.0 REVENUE BUDGET for every month from Jan to Jun 2021 April May Event sales 2,250 3,000 Retail sales 35,000 33,600 Total sales 37,250 36,600 June 1,500 31,500 33,000 Total 6,750 100,100 106,850 PRODUCTION BUDGET for every month from Jan to Jun 2021 Additional information: The shop produces on order so there is no begining and ending finished inventory. June Total sales in liters Desired ending inventory Beginning inventory Budgeted production April 1,850 0 0 1,850 May 1,832 0 0 1,832 1,630 0 0 1,630 Total 5,312 0 0 5,312 DIRECT MATERIAL PURCHASE BUDGET for every month from Jan to Jun 2021 Additional information: to maintain the freshness of all fruits and veggie, all materials are deliverd every morning by a fresh fruit and veggie supplier. So, there is no begining or ending raw materials is kept on site. DM Per liter 0.1 0.1 0.05 0.5 DM Purchase (quantity) Budgeted production Avocado (kg) Banana(kg) Baby Spinach (kg) Coconut water (liter) DM Purchase budget ($) Avocado (kg) Banana(kg) Baby Spinach (kg) Coconut water (liter) Total DM budget ($) April 1,850.00 284.62 231.25 92.50 925.00 April 1,707.69 $ 693.75 $ 832.50 $ 1,850.00 $ 5,083.94 $ May 1,832.00 281.85 229.00 91.60 916.00 May 1,691.08 $ 687.00 $ 824.40 $ 1.832.00 $ 5,034.48 $ June Total 1,630.00 5,312.00 250.77 817.23 203.75 664.00 81.50 265.60 815.00 2,656.00 June Total 1,504.62 $ 4.903.38 611.25 $ 1,992.00 733.50 $ 2,390.40 1,630.00 $ 5,312.00 4,479.37 $ 14,597.78 Price per unit 6 $ 3 $ 9 $ 2 $ $ DIRECT LABOUR BUDGET for every month from Jan to Jun 2021 Additional information: The shop has two staff, both involving in make the juice and cashier tasks, as well as cleaning and admin tasks. Each is paid $20 per hour. The shop opens from 9am to 5pm every day for 5 days per week. Direct labour budget Hours worked Pay per hour Total pay ($) April 352 20.00 $ 7,040.00 $ May 336 20.00 $ 6,720.00 $ June 352 20.00 $ 7,040.00 $ Total 1040 20.00 20,800.00 $ OVERHEAD BUDGET for every month from Jan to Jun 2021 Additional information: The shop is rented for $3,000 per month excluding utilities (1), estimated utiltity bill is $300 per month, public insurance covers both public and product liability is $168 per year (2). There are two commercial blenders being used, each costs $499, with 7 year warranty (3). The blenders are expected to have useful life of 10 years each with no residual value. A big fridge is used to store veggie and fruits costs $1,600 including delivery and installation (4). The fridge is expected to have 10 years useful life. According to ATO simplified depreciation rules, these assets are eligible for instant write-off. However, the business owners wants to use straightline depreciation of the assets over their useful life. The shop runs a Facebook page and a YouTube channel to share healthy recipes and tips, and hires a student to maintain these social media channels for 1 hour per day, and pays him $20 per hour. Manufacturing overhead Utilities Rent Insurance Depreciation Total MOH $ $ 9 94 April 300.00 3,000.00 $ 14.00 $ 21.65 $ 3,035.65 $ May 300.00 3,500.00 $ 14.00 $ 21.65 $ 3,535.65 $ June 300.00 3,500.00 $ 14.00 $ 21.65 $ 3,535.65 $ Total 900.00 10,000.00 42.00 64.95 11,006.95 $ Supporting activity budget Social media activities April 440.00 $ May 420.00 $ June 440.00 $ Total 1,300.00 $ Budgeted cost of sales DM usgae DL cost MOH Total cost of manufactured Less ending inventory Cost of sales $ $ $ $ $ 000000 April May June 5,083.94 $ 5,034.48 $ 4,479.37 $ 7,040.00 $ 6,720.00 $ 7,040.00 $ 3,035.65 $ 3,535.65 $ 3,535.65 $ 15,159.59 $ 15,290.13 $ 15,055.02 $ $ $ $ 15,159.59 $ 15,290.13 $ 15,055.02 $ Total 14,597.78 20,800.00 10,106.95 45,504.73 45,504.73 Bugeted profit or loss for April - June 2021 April May June Sales $ 37,250.00 $ 36,600.00 $ 33,000.00 $ Cost of sales $ 15,159.59 $ 15,290.13 $ 15,055.02 $ Gross margin $ 22,090.41 $ 21,309.87 $ 17,944.98 $ Selling expense $ 440.00 $ 420.00 $ 440.00 $ Net profit 21,650.41 $ 20,889.87 $ 17,504.98 $ A A A Total 106,850.00 45,504.73 61,345.27 1,300.00 60,045.27 The shop sells juice to staff and students in Agora, Bundoora campus of La Trobe university, and also offer delivery sales to commercial order for party and events which order minimum 20 liters per order. Price for event sale will be $15 per liter. Free delivery will be applied for orders that exceed 50 liters. The shop has received some orders of Wakeup Juice to a monthly event organized by Victorian Vegan society (100 liters per order) and some corporate events in April and May. The Vegan society's events wil be held on the first Saturday of every month from March to December. The corporate events will be held on 3rd April and 31th May. The following table provides estimated sales in the second quarter of 2021. Sales Event sales (liters) Retail sales (unit) April 150 5000 May 200 4800 June 100 4500 Price ($) 15 7 Policy on collection of sales and collection of account receivable: (1) 100% Retail sales are on cash (2) Event sales: 20% deposit 10 days before the event and the remaining collected anytime within 1 week from the event day. 1% discount given for event sales which exceeds $2000 in value. Policy on Purchase of direct materials and payment for purchase: (3) To maintain high quality of product, 100% of ingredients needed for production is purchased everyday fresh. (4) Payments for purchase will be made everyday when ingredients are received. The suppliers give 2% discount for order which exceeds $1000 in value. (5) All direct materials purchases are made according to the standard quantity of direct materials allowed for updated budgeted production at the original budgeted prices. Additional information about expenses and other payments forecasted for April-June 2021: (6) Manufacturing overhead costs include variable overhead and fixed overhead expenses are estimated to be the same as the estimation in the initial budget. Cash MOH expenses are paid as incurred. Insurance is paid in January for the whole year. (7) Direct labour cost are paid as incurred. (8) The shop maintain a Facebook and a YouTube channel on Fresh Smoothies and a student is hired to maintain these social media channel for 1 hour every day, 5 days a week, and get paid $22 per hour, paid on Wednesday of the 2nd and 4th week of the month. (9) Opening balance at bank is $7,200 on 1st April 2021. Heathy Food Bar Cash budget for April-June 2021 period April May June Total Cash receipt Retail sales Event sales Vegan society (100L) Corporate event Total receipts April May June Total Cash disbursement DM costs DL costs MOH costs Social media activities Total disbursement April May June Total Cash balance Net cash Opening Cash balance Ending Cash balance Product name Report type Wakeup Juice (WUJU) Standard Unit costs (STD_UC) Direct Cost of 1 liter WUJU 6. Direct materials Avocado flesh (kg) Banana flesh (kg) Baby Spinach (kg) Coconut water Total DM Amount in recipe Unit price of ingrdient Standard costs 0. 0.92 0.1 3 0.375 0.05) 9 0.45 0.51 2 2.75 Direct labour 2 staff Total DL per 1000ml DL hours/month Rate ($/hr) 352 Labour cost per month 20 7040.00 4.32 Direct cost per 1000ml 7.07 Per month Manufacturing overhead Utilities (electricity+gas+water) Depreciation of blender Rent Insurance MOH per 100ml Allocation 300 output 21.65 output 3000 output 14 output Qty of allocation Cost per 1000ml 1630 0.181 1630 0.01 1630 1.84 1630 0.01 2.05 Per 1000 ml Medium (340ml) 9.11 Source: Production costs Paper Cup Standard cost each product Budgeted selling price 3.10 0.095 3.19 8.00 Per day/blender (1) Per month per blender Number of blender Total capacity Maximum capacity 50 1100 2 2200 Budgeted sales and production per month Estimated event sale (liters) Estimated retail sales (units) Total estimated sales (liters) Estimated output per month (litres) Blender cost ($) Fridge Expected useful life (years) Per month depreciation Rent Insurance per year Total fixed MOH per month Variable MOH per month MOH per liter 100 4500 1630 1630 998 1600 10 21.65 3000 168 3035.65 300 2.05 Assumptions Avocado Banana 65% % of flesh/whole fruit 80% Product name Standard cost per liter Wakeup Juice (WUJU) 9.11 Direct materials Avocado flesh (kg) Banana flesh (kg) Baby Spinach (kg) Coconut water (1) Unit price of Amount in recipe ingrdient ($) 0.1 6 0.1 3 0.05 9 0.5 2 COO Average weight (gr) % of flesh Flesh Avocado Banana 170 118 65% 80% 110.5 94.4 FORECAST FOR the second quarter of 2021 (From April to Jun) Sales Event sales (liters) Retail sales (unit) April 150 5000 May 200 4800 June 100 4500 Price ($) 15 7.0 REVENUE BUDGET for every month from Jan to Jun 2021 April May Event sales 2,250 3,000 Retail sales 35,000 33,600 Total sales 37,250 36,600 June 1,500 31,500 33,000 Total 6,750 100,100 106,850 PRODUCTION BUDGET for every month from Jan to Jun 2021 Additional information: The shop produces on order so there is no begining and ending finished inventory. June Total sales in liters Desired ending inventory Beginning inventory Budgeted production April 1,850 0 0 1,850 May 1,832 0 0 1,832 1,630 0 0 1,630 Total 5,312 0 0 5,312 DIRECT MATERIAL PURCHASE BUDGET for every month from Jan to Jun 2021 Additional information: to maintain the freshness of all fruits and veggie, all materials are deliverd every morning by a fresh fruit and veggie supplier. So, there is no begining or ending raw materials is kept on site. DM Per liter 0.1 0.1 0.05 0.5 DM Purchase (quantity) Budgeted production Avocado (kg) Banana(kg) Baby Spinach (kg) Coconut water (liter) DM Purchase budget ($) Avocado (kg) Banana(kg) Baby Spinach (kg) Coconut water (liter) Total DM budget ($) April 1,850.00 284.62 231.25 92.50 925.00 April 1,707.69 $ 693.75 $ 832.50 $ 1,850.00 $ 5,083.94 $ May 1,832.00 281.85 229.00 91.60 916.00 May 1,691.08 $ 687.00 $ 824.40 $ 1.832.00 $ 5,034.48 $ June Total 1,630.00 5,312.00 250.77 817.23 203.75 664.00 81.50 265.60 815.00 2,656.00 June Total 1,504.62 $ 4.903.38 611.25 $ 1,992.00 733.50 $ 2,390.40 1,630.00 $ 5,312.00 4,479.37 $ 14,597.78 Price per unit 6 $ 3 $ 9 $ 2 $ $ DIRECT LABOUR BUDGET for every month from Jan to Jun 2021 Additional information: The shop has two staff, both involving in make the juice and cashier tasks, as well as cleaning and admin tasks. Each is paid $20 per hour. The shop opens from 9am to 5pm every day for 5 days per week. Direct labour budget Hours worked Pay per hour Total pay ($) April 352 20.00 $ 7,040.00 $ May 336 20.00 $ 6,720.00 $ June 352 20.00 $ 7,040.00 $ Total 1040 20.00 20,800.00 $ OVERHEAD BUDGET for every month from Jan to Jun 2021 Additional information: The shop is rented for $3,000 per month excluding utilities (1), estimated utiltity bill is $300 per month, public insurance covers both public and product liability is $168 per year (2). There are two commercial blenders being used, each costs $499, with 7 year warranty (3). The blenders are expected to have useful life of 10 years each with no residual value. A big fridge is used to store veggie and fruits costs $1,600 including delivery and installation (4). The fridge is expected to have 10 years useful life. According to ATO simplified depreciation rules, these assets are eligible for instant write-off. However, the business owners wants to use straightline depreciation of the assets over their useful life. The shop runs a Facebook page and a YouTube channel to share healthy recipes and tips, and hires a student to maintain these social media channels for 1 hour per day, and pays him $20 per hour. Manufacturing overhead Utilities Rent Insurance Depreciation Total MOH $ $ 9 94 April 300.00 3,000.00 $ 14.00 $ 21.65 $ 3,035.65 $ May 300.00 3,500.00 $ 14.00 $ 21.65 $ 3,535.65 $ June 300.00 3,500.00 $ 14.00 $ 21.65 $ 3,535.65 $ Total 900.00 10,000.00 42.00 64.95 11,006.95 $ Supporting activity budget Social media activities April 440.00 $ May 420.00 $ June 440.00 $ Total 1,300.00 $ Budgeted cost of sales DM usgae DL cost MOH Total cost of manufactured Less ending inventory Cost of sales $ $ $ $ $ 000000 April May June 5,083.94 $ 5,034.48 $ 4,479.37 $ 7,040.00 $ 6,720.00 $ 7,040.00 $ 3,035.65 $ 3,535.65 $ 3,535.65 $ 15,159.59 $ 15,290.13 $ 15,055.02 $ $ $ $ 15,159.59 $ 15,290.13 $ 15,055.02 $ Total 14,597.78 20,800.00 10,106.95 45,504.73 45,504.73 Bugeted profit or loss for April - June 2021 April May June Sales $ 37,250.00 $ 36,600.00 $ 33,000.00 $ Cost of sales $ 15,159.59 $ 15,290.13 $ 15,055.02 $ Gross margin $ 22,090.41 $ 21,309.87 $ 17,944.98 $ Selling expense $ 440.00 $ 420.00 $ 440.00 $ Net profit 21,650.41 $ 20,889.87 $ 17,504.98 $ A A A Total 106,850.00 45,504.73 61,345.27 1,300.00 60,045.27 The shop sells juice to staff and students in Agora, Bundoora campus of La Trobe university, and also offer delivery sales to commercial order for party and events which order minimum 20 liters per order. Price for event sale will be $15 per liter. Free delivery will be applied for orders that exceed 50 liters. The shop has received some orders of Wakeup Juice to a monthly event organized by Victorian Vegan society (100 liters per order) and some corporate events in April and May. The Vegan society's events wil be held on the first Saturday of every month from March to December. The corporate events will be held on 3rd April and 31th May. The following table provides estimated sales in the second quarter of 2021. Sales Event sales (liters) Retail sales (unit) April 150 5000 May 200 4800 June 100 4500 Price ($) 15 7 Policy on collection of sales and collection of account receivable: (1) 100% Retail sales are on cash (2) Event sales: 20% deposit 10 days before the event and the remaining collected anytime within 1 week from the event day. 1% discount given for event sales which exceeds $2000 in value. Policy on Purchase of direct materials and payment for purchase: (3) To maintain high quality of product, 100% of ingredients needed for production is purchased everyday fresh. (4) Payments for purchase will be made everyday when ingredients are received. The suppliers give 2% discount for order which exceeds $1000 in value. (5) All direct materials purchases are made according to the standard quantity of direct materials allowed for updated budgeted production at the original budgeted prices. Additional information about expenses and other payments forecasted for April-June 2021: (6) Manufacturing overhead costs include variable overhead and fixed overhead expenses are estimated to be the same as the estimation in the initial budget. Cash MOH expenses are paid as incurred. Insurance is paid in January for the whole year. (7) Direct labour cost are paid as incurred. (8) The shop maintain a Facebook and a YouTube channel on Fresh Smoothies and a student is hired to maintain these social media channel for 1 hour every day, 5 days a week, and get paid $22 per hour, paid on Wednesday of the 2nd and 4th week of the month. (9) Opening balance at bank is $7,200 on 1st April 2021. Heathy Food Bar Cash budget for April-June 2021 period April May June Total Cash receipt Retail sales Event sales Vegan society (100L) Corporate event Total receipts April May June Total Cash disbursement DM costs DL costs MOH costs Social media activities Total disbursement April May June Total Cash balance Net cash Opening Cash balance Ending Cash balance