Question

In: Accounting

DC's has been approached by a large grocery store chain that wants to sell their award...

DC's has been approached by a large grocery store chain that wants to sell their award winning BBQ sauce. Determine the selling price based on the following information:

Fixed costs for production will be $400,000 of which $150,000 is for selling and admin expenses.

Variable costs will be $15 per case. Variable selling expenses are $3 per case.

Anticipated sales are 100,000 cases.

DC's desires a $350,000 profit.

What does the selling price per case need to be?

After visiting with customers of the DC's restaurant, the grocery chain also wants to produce DC's Dry Seasoning Rub.

Determine the selling price for the Rub based on the following combined information:

Variable Costs Fixed Costs
Manufacturing 2,700,000 300,000
Selling and Administrative 450,000 200,000
Total 3,150,000 500,000

Desired profit from Rub sales = $150,000

The Cost for 1 case of Rub is:

Direct Materials $ 9
Direct Labor $ 7

Manufacturing Overhead:

Variable $ 3
Fixed $ 2
Total Manufacturing Costs $ 21
Variable Selling and Admin $ 3

Required:

1. Determine the markup percentage on variable costs required to earn the desired profit.

2. Use the variable markup percentage to determine the suggested price of the Rub.

3. Determine the markup percentage on manufacturing costs to earn the desired percentage

4. Determine the suggested price of the Rub using manufacturing cost markup.

Solutions

Expert Solution

1.

markup percentage on variable cost
Desired Profit $        1,50,000.00
Add: Fixed Cost $        5,00,000.00
Required Markup $        6,50,000.00
Variable Cost $      31,50,000.00
Mark Up % (650000/3150000) 20.63%

2.

Variable cost per unit (9+7+3+3) $                    22.00
Mark up (22*20.63%) $                       4.54
Selling price per unit   $                    26.54

3.

Markup percentage on Manufacuring cost
Desired Profit $        1,50,000.00
Add: selling and administrative cost
(450000+200000)
$        6,50,000.00
Required Markup $        8,00,000.00
Manufacturing cost (2700000+300000) $      30,00,000.00
Mark Up % (800000/3000000) 26.67%

4.  

Manufacturing cost per unit

(9+7+3+2)  

$                    21.00
Mark up (21*26.67%) $                       5.60
Selling price per unit   $                    26.60

Related Solutions

A national grocery store chain wants to test the difference in the average weight of turkeys...
A national grocery store chain wants to test the difference in the average weight of turkeys sold in Detroit and the average weight of turkeys sold in Charlotte. According to the chain's researcher, a random sample of 20 turkeys sold at the chain's stores in Detroit yielded a sample mean of 17.53 pounds, with a sample standard deviation of 3.2 pounds. And a random sample of 24 turkeys sold at the chain's stores in Charlotte yielded a sample mean of...
The management for a large grocery store chain would like to determine if a new cash...
The management for a large grocery store chain would like to determine if a new cash register will enable cashiers to process a larger number of items on average than the cash register they are currently using. Seven cashiers are randomly selected, and the number of grocery items they can process in three minutes is measured for both the old cash register and the new cash register. The results of the test are as follows: Cashier Old Cash Register Old...
Dorothy O’Connon has recently left her job as a florist at a grocery store chain to...
Dorothy O’Connon has recently left her job as a florist at a grocery store chain to start her own business, Dorothy’s Floral Delivery. She is trying to determine her break-even point. She plans to sells two types of flower arrangements. Based on her research, she is projecting the sales mix to be 60% basic flower arrangements and 40% deluxe flower arrangements. Basic arrangements have a variable cost per unit of $9.8 and a selling price of $21.56. Deluxe arrangements have...
A grocery store purchases bags of oranges from California to sell in their store. The weight...
A grocery store purchases bags of oranges from California to sell in their store. The weight of a bag of California oranges is normally distributed with a mean of 7.1 pounds and a variance of 1.21 pounds2. A bag of California oranges is randomly selected in the grocery store. (Round all probability answers to four decimal places.) a. What is the probability that a randomly selected California orange bag purchased by a customer weighs more than 8 pounds? b. What...
A grocery store purchases bags of oranges from California to sell in their store. The weight...
A grocery store purchases bags of oranges from California to sell in their store. The weight of a bag of California oranges is normally distributed with a mean of 7.7 pounds and a variance of 1.21 pounds2. A bag of California oranges is randomly selected in the grocery store. (Round all probability answers to four decimal places.) a. What is the probability that a randomly selected California orange bag purchased by a customer weighs more than 8 pounds? b. What...
You are a grocery store manager. The owner has a lot to say about how your run the store. The owner wants the grocery store to start selling rotisserie chickens.
You are a grocery store manager. The owner has a lot to say about how your run the store. The owner wants the grocery store to start selling rotisserie chickens. This is a new product. You know that you can buy chickens from a local farmer for $2/chicken and it would take you an additional $0.20/chicken to cook it. The grocery store currently pays $4,000/month in mortgage (unrelated to the chickens) and would spend $300 advertising the new rotisserie chickens....
Calculating a Bid Price Your company has been approached to bid on a contract to sell...
Calculating a Bid Price Your company has been approached to bid on a contract to sell 15,000 voice recognition (VR) computer keyboards a year for four years. Due to technological improvements, beyond that time they will be outdated and no sales will be possible. The equipment necessary for the production will cost $3.4 million and will be depreciated on a straight-line basis to a zero salvage value. Production will require an investment in net working capital of $75,000 to be...
Your company has been approached to bid on a contract to sell 5,050 voice recognition (VR)...
Your company has been approached to bid on a contract to sell 5,050 voice recognition (VR) computer keyboards a year for four years. Due to technological improvements, beyond that time they will be outdated and no sales will be possible. The equipment necessary for the production will cost $3.6 million and will be depreciated on a straight-line basis to a zero salvage value. Production will require an investment in net working capital of $420,000 to be returned at the end...
Your company has been approached to bid on a contract to sell 5,700 voice recognition (VR)...
Your company has been approached to bid on a contract to sell 5,700 voice recognition (VR) computer keyboards a year for four years. Due to technological improvements, beyond that time they will be outdated and no sales will be possible. The equipment necessary for the production will cost $4.9 million and will be depreciated on a straight-line basis to a zero salvage value. Production will require an investment in net working capital of $485,000 to be returned at the end...
Your company has been approached to bid on a contract to sell 3,600 voice recognition (VR)...
Your company has been approached to bid on a contract to sell 3,600 voice recognition (VR) computer keyboards a year for four years. Due to technological improvements, beyond that time they will be outdated and no sales will be possible. The equipment necessary for the production will cost $3.2 million and will be depreciated on a straight-line basis to a zero salvage value. Production will require an investment in net working capital of $89,000 to be returned at the end...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT