The purpose of this case study is to help you integrate the managerial accounting concepts that were covered in class and apply them to a real-world business setting. Business Description Daisy, a friend who is an excellent baker, has decided to open a cupcake store to sell gourmet cupcakes.

Daisy has asked you if you will be willing to loan the company $50,000 at an interest rate of 4% that will be paid back over 5 years. You will analyze the business to determine if you will loan Daisy the money. The business is scheduled to launch on January 1, 2019. Daisy has provided you with the following cost information.

Cost information:

Cost of goods sold: a. Ingredients are .30 per cupcake b. Cupcake Cups are .01 per cupcake

Daisy has found a fully equipped commercial kitchen near downtown with a store front that will be rented for $1,000 per month.

Utilities will be $125 per month.

On average one person can make, bake, and decorate 36 cupcakes per hour. Bakers are paid $18.00 per hour.

A worker will be needed for the store front to sell the cupcakes. Daisy plans to open the store 7 days per week from 11:00 AM until 7:00 PM. Sales people will be paid $9.00 per hour.

Business insurance is purchased at a cost of $750 per year.

Advertising costs are expected to be $3,600 per year.

TOTAL VARIABLE COST: $1.15

TOTAL FIXED COST: $17,850.00

Y = $17,850.00 + $1.15X

Contribution Margin $48,000

Contribution Margin Ration: $58.18%

BEP: 11,156 Units

BEP $: $30,679

Requirements: Using separate tabs in a spreadsheet, provide your answers for the following.

1 Prepare a cost/volume/profit graph (15 points).

2 Based on the expected production of 30,000 cupcakes, calculate an overhead rate per cupcake that includes rent, utilities, and insurance (5 points).

3 If Daisy wanted to use activity based costing, identify a minimum of 3 different activities and an appropriate cost driver for each. (10 points)

4 Prepare a cash budget for the companys first year of operations based on sales of 30,000 cupcakes. Assume all sales are cash sales and that all costs and expenses are paid in cash. Rent, insurance, and advertising costs will be paid on a monthly basis. The interest on the loan will be paid monthly with a $10,000 principal payment at the end of the year. A minimum cash balance of $5,000 should be maintained (15 points).

5 Prepare the companys forecasted income statement for the year ended on 6/30/2019 based on the sale of 30,000 cupcakes (10 points).

6 Describe the variances that Daisy should analyze to monitor the business. (10 points)

7 Provide at least 4 metrics that Daisy could include to monitor the business using a balanced scorecard approach. (10 points)

8 If Daisy decides to expand her business by investing in her own equipment, which capital budgeting model would you recommend? Why? (10 points)

9 Will you lend $50,000 to Daisy to start her business? Based on the calculations performed explain why or why not (10 points).