Template

Instructions

Grading

Managerial Accounting

Project #$2$

Break$-$even Cookie Project

Name of Business:

Type of Cookie Being Sold:

How Many Cookies Will you Sell?

$2.$ Direct Materials Cost

Ingredients

$\backslash$table$[[,,],[,,],[,,],[,,],[,,],[,,],[,,],[,,],[,,],[,,],[,,],[,,]]$

Total Direct Materials Cost

$3.$ Direct Labor Cost

Employee Title

Hourly Rate

Total

urs to Mak

Cookies

Cookies

Lab

$=$ Fill in the Blank

$\backslash$table$[[,$Hourly Rate,$\backslash$table$[[$Hours to Make all$],[$Cookies$]],$Labor Cost$],[,,,0,$For Part $9.],[,,,0,],[,,,0,],[,,,0,],[,,,0,]]$

Total Direct Labor Cost Per Cookie

$4.$ Manufacturing Overhead

Type of Manfacturing Overhead Expense

Estimated MFG

Fixed or Variable OH Cost Expense? For Par

$\backslash$table$[[,,],[,,],[,,],[,,],[,,],[,,],[,,],[,,],[,,],[,,]]$

Manufac Cost turing Overhe

Cookie turing Ov

Cookie

$6.$ Operating Expenses

Operating Expense

$\backslash$table$[[,,],[,,],[,,],[,,],[,,],[,,],[,,],[,,],[,,],[,,],[,,],[,,]]$

Total Estimated Operating Expenses

per

$\backslash$tablefrom Step $5)]]$

Estimated Cost of Fixed or Variable Operating Expense? For Par Expense

Expense? $9.$

$9.$ Breakeven Calculation $-$ How many cookies will you need to sell to breakeven?

Use one of the three methods presented in Chapter $7$ to calculate breakeven in un

$($Hint $-$ you will need to determine which of your expenses are fixed vs$.$ variable. Remember variable costs change with

changes in volume, and fixed costs remain the same regardless of volume produced$).$

$5.$ Calculation of Manufacturing Overhead Allocation Per Cookie $-$ Plantwide O$/$H Rate Metho

$10.$ Target Profit Calculation $-$ How many cookies will you need to sell to achieve a target profit of $$50,000?$ Use one of the three methods presented in Chapter $7$ to calculate target

$9$:$32$

$100$

MA$20-20$Project$202322...$ment$20$Details$20($Online$)$

This project will focus on applying your knowledge product costing, breakeven analysis, and achieving a target profit.

For this project you will be a small business owner selling cookies. You will determine the name of your business and what type of cookies you'd like to sell. Complete the following criteria in the excel workbook provided.

List your business name, type of cookie being sold, and your estimated quantity to be sold in your workbook. $($Make sure to populate your estimated quantity to be sold or other areas of your workbook will not populate correctly$).$

Select any cookie recipe. In the workbook provided you'll identify all of the ingredients, the direct materials to make the cookies. Include the cookie recipe in your workbook.

List all of the ingredients and record in your workbook. Determine the cost to purchase all of your ingredients. Calculate your total direct materials cost. You can do this buy visiting a local grocery store, or looking up the costs online $($BJ$\text{'}$s$,$ Sam's Club, Walmart, etc.$)$ You total direct material cost should be to make all of your cookies.

Determine your direct labor cost. How many employees will you need to manufacture and sell your cookies? Record all of your employees and their pay rates. Determine how many hours each employee will work. Calculate your total direct labor cost. Your total direct labor cost should be to make all of your cookies.

Determine your manufacturing overhead costs. What other expenses will you incur to operate your cookie business? Think about what you know about indirect costs $-$ things you will need but cannot directly trace back to the cost of the cookies. Record and estimate all of your manufacturing overhead costs. Calculate your total manufacturing overhead costs.

Using the plant$-$wide overhead rate as your manufacturing overhead allocation method, calculate how much manufacturing overhead cost will be allocated to each cookie. Show your calculation!

Will you have any other operating expenses related to your cookie business? List any additional operating expenses you may have and estimate their cost.

After analyzing the cost to make a cookie determine how much you will sell your cookie for. Record your selling price.

Review your projected income statement based on your inputs from above. Make sure your cookie business is profitable or you'll need to adjust your plan. What is your profit margin? How do you feel about your results?

Based on your selling price and total costs, how many cookies will you need to sell to breakeven? Use any of the three methods from Chapter $7$ to calculate breakeven in units, show your calculation! $($Hint $-$ you will need to determine which of your expenses are fixed and which are variable$)$

$10.$If you want to achieve a target profit of $$50,000,$ how many cookies will you need to sell? Show your calculation!profit in units $-$ show your work!