Explain:

Review your Project Submission from Module 01 where you developed a job cost card for your cookie and made a list of potential overhead costs.

1 - an 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 prepare 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?

Cost per Cookie For Example: Customer orders 1 dozen cookies How much will they be charged. Each cookie cost $0.93 Cost per dozen = $14Job Costing Card Manufacturing Direct Materials Direct Labor Manufacturing Overhead Department Cost Hours Cost Rate Cost Applied Production 55,000 20,800 312,000 $2 624,000 Equipment 85,000 Internet Cost 1200 Clover/Square 3000 Health inspection 4000