1 - Excel spreadsheet as outlined below. Be sure that your completed spreadsheet has answers to all the questions below.

2 - In a table, on the first tab of the spreadsheet, classify your costs as variable, fixed, or mixed.

Note: Now that you have a more robust understanding of cost accounting you may need to add some overhead costs to your list. Think about both the ecommerce costs as well as the production facility costs.

3 - On the second tab of your Excel spreadsheet, a high-low analysis of your electric costs using the following data. What is your fixed cost of electricity? What is the variable cost of electricity?

Month: January

Kilowatt Hours used: 1866

Electric costs: $230

Month: February

Kilowatt Hours used: 1439

Electric costs: $202

Month: March

Kilowatt Hours used: 1146

Electric costs: $197

Month: April

Kilowatt Hours used: 1046

Electric costs: $190

Month: May

Kilowatt Hours used: 996

Electric costs: $182

Month: June

Kilowatt Hours used: 1760

Electric costs: $225

4 - On the third tab of your spreadsheet a daily contribution margin income statement based on your cost card from Module 01.

Note: You must make some realistic assumptions about your fixed costs, sales level, and selling and administrative costs. Be sure to list all your assumptions. What is the contribution margin ratio?

5 - On the fourth tab of your spreadsheet, calculate the break-even in number of cookies per day. What is the break-even in sales dollars each day? How many cookies must you sell to earn a daily profit of $1000? Does this seem realistic?

Cut AutoSum * Calibri 11 AA E Wrap Text General H AY it BB Copy Fill Paste BIU - Merge & Center . $ - % " .00 Conditional Format as Cell Insert Delete Format Sort & Find & Format Painter Formatting Table Styles Clear Filter . Select Clipboard F Font Alignment Number Styles Cells Editing D13 X V fx A B C D E F G H J K L M N O P Q R S T W N Types of Costs Plan to sell 1400 Bars a week Fixed Costs Variable Costs Mixed Costs Labor Delivery costs Utility costs $ 5.25 $ 15.00 $ 200.00 Equipment maintenance Packaging materials S 2.00 $ 170.00 Insurance Cookie Ingredients S 4.00 $ 400.00 Advertising Internet 70.00 $ 50.00 Selling & Admin Expenses $ 18.00 10 13 14 15 16 17 18 19 20 21 22 23 Classifying Costs High-Low Analysis Contribargin Income Statement Break Even Point (+Cut Calibri 11 A A" = AutoSum Be Wrap Text General A Be Copy Fill - Paste Format Painter BIU . Merge & Center $ - % " 00 Conditional Format as C Insert Delete Format Sort & Find & Formatting * Table Styles Clear Filter . Select Clipboard Font Alignment F Number Styles Cells Editing D22 X v fx A B C D E F G H K L M N O P Month Kilowatt Hours Used Electric Costs January 1866 $ 230 February 1439 $ 202 March 1146 197 April 1046 190 May 996 $ 182 10 June 1760 225 Kilowatt Hours Used Total costs 14 High activity Month (January) 1866 230 15 Low activity Month (May) 996 182 16 17 Variable cost per unit= Difference in cost/difference in units 18 Variable cost= 0.055 19 20 Fixed costs= Total cost- Fixed cost= 127.05 21 (Variable Cost*Units used) 22 23 1 Classifying Costs High-Low Analysis Contribargin Income Statement Break Even Point +Cut AutoSum Calibri 11 AA Of Wrap Text General EX AY H Be Copy Fill - Paste BIU - Y . A. BE Merge & Center $ - % " .00 Conditional Format as Cell Insert Delete Format Sort & Find & Format Painter Formatting * Table Styles Clear Filter * Select Clipboard G Font G Alignment Number Styles Cells Editing 14 X Vfx Sell 2400/wk, 200/day A B C D E F G H J K L M N O P Q DC Bars W N Selling Price = $2.50/bar MoonC Bars Sell 2400/wk, 200/day Daily Income Statement 70 batches made/wk 14 batches/day, 5 days/wk 20 working days/month Sales ($2.50 x 200) $ 500.00 9 Cost of Goods Sold ($1.15 x 286) 230.00 10 Gross Margin $ 270.00 11 Less Selling and Admin Expenses: plan to sell 12 Selling Expense $ 18.00 per batch $ 5.25 $ 15.00 $ 200.00 13 Admin Expense $ 18.00 $ 36.00 per batch S 2.00 $ 170.00 14 Net Income $ 234.00 per batch S 4.00 $ 400.00 15 per month $ 70.00 $ 50.00 16 Total VC per day $ 159.83 $ 18.00 17 VC per unit $ 0.80 18 Total FC/day $ 529.00 19 Contribution Margin Ratio= $ 1.70 FC/unit $ 2.65 = 0.68 20 $ 2.50 21 22 23 Classifying Costs High-Low Analysis Contribargin Income Statement Break Even Point +16 Cut Calibri 11 E Be Wrap Text General EX _ AutoSum * AY H BE Copy + Fill - Paste Format Painter BIU . Merge & Center . $ - % " 3.0 Conditional Format as Cell Insert Delete Format Sort & Find & Formatting Table * Styles 2 Clear Filter . Select Clipboard Font Alignment Number Styles Cells Editing 131 X V fx B C D E F G H I K L M N O P Q R 19 $ 777.50 20 21 22 To earn $1000, MoonC needs 23 24 = 1000 + 529 25 2.50 - .8 26 27 = 1529 28 1.7 29 30 = 899.4117647 31 32 MoonC needs to sell 900 Bar/day 33 34 35 According to what I calculated, MoonC would have to sell 900 Bar/day to earn a 36 daily profit of $1,000. This means they would have to make 63 batches a day. They 37 are already making 14 batches a day. From this, the goa the business have in mind 38 doesn't seem possible at the current moment and power. 39 40 41 Classifying Costs High-Low Analysis Contribargin Income Statement Break Even Point + mX Cut 11 A Of Wrap Text General EX AutoSum Calibri AY # Copy Fill - Paste Conditional Format as Cell Insert Delete Format Sort & Find & Format Painter BIU . A E = Merge & Center $ - % " Formatting Table * Styles Clear Filter . Select Clipboard G Font Alignment F Number G Styles Cells Editing B22 X V fx To earn $1000, MoonC needs B C D E F G H I J K L M N O P Q R W N - Break-even point VC/Unit $ 0.80 SP(X) - VC(X) - TFC VC/Day $ 159.83 Total FC/day $529.00 6 = 2.50(X) - .8(X) - 529.00 FC/unit $ 2.65 7 8 1.7(x) - 254.48 LO 10 X= 310.588 11 12 Break-even= 311 units/day 13 14 15 16 Break-even in sales dollars 17 18 = 311 x 2.50 19 = $ 777.50 20 21 22 To earn $1000, MoonC need 23 Classifying Costs High-Low Analysis Contribargin Income Statement Break Even Point (+