ACC20014 Assignment Cake 2 Cake 1 Cake 3 Aussie bakery bakes

ACC20014 Assignment Cake 2 Cake 1 Cake 3 Aussie bakery bakes only three types of cakes for a large retailer Oven Oven electricity consumption is 25kwh. 25kwh ACC20014

Solution

1)

*Assuming all your calculatons are correct.

Total Electricity Usage Throughout the year = 13,075 + 12,129 + 10,386 + 9112.9 + 10,209 + 10732.2 + 11708.4 + 11902.5 + 11955 + 12,487.9 + 12,936 + 13,900 = 140533.9 KWH

Electricity provider 2 is cheapest.

2)

Calculations For 1st month..

Remaining 7575

(13075-5500)

Remaining 7575

(13075-5500)

Don\'t know the formula or method, how to put them on excel sheet.

Mothly...convert into yearly	Electricity Provider 1	Months...Convert Yearly	Electricity Provider 2
First 3350*12 = 40,200 kwh	1,197,960	First 2550*12 = 30,600 kwh	904,230
Between 40,200 to 66,000 kwh	774,000	Between 30,600 to 66,000 (5500*12)Kwh	1,026,600
Thereafter (140533.9 - 66,000)	2,236,762.339	Thereafter (140533.9 - 66,000)	2,142,849.625
Supply Charges per day (365 Days)	1464.38	Supply Charges per day (365 Days)	1,825
Total Charges	4,210,186.719$		4,075,504.625