Question

13. Carter Inc. is planning to launch an energy har in two flavors, demand of which ext 3 months as shown. Each bar has been

0 0
Add a comment Improve this question Transcribed image text
Answer #1

a) Linear program is following:

Decision variables:

Let P1, P2, P3 be the number of peanut POWER energy bars to be produced in month 1, 2 and 3 resp

C1, C2, C3 be the number of peanut CRUNCH energy bars to be produced in month 1, 2 and 3 resp

PV1, PV2, PV3 be the ending inventory of peanut POWER in month 1, 2, 3 resp

CV1, CV2, CV3 be the ending inventory of peanut CRUNCH in month 1, 2, 3 resp

Objective:

Minimize 2P1+2P2+2P3+2.5C1+2.5C2+2.5C3+.1PV1+.1PV2+.1PV3+.15CV1+.15CV2+.15CV3

Constraints:

P1-PV1 = 30000-10000

P2-PV2+PV1 = 50000

P3-PV3+PV2 = 40000

C1-CV1 = 80000-20000

C2-CV2+CV1 = 100000

C3-CV3+CV2 = 70000

60P1+40C1 <= 5000000

60P2+40C2 <= 6000000

60P3+40C3 <= 7000000

.01P1+.015C1 <= 1500

.01P2+.015C2 <= 2000

.01P3+.015C3 <= 2000

PV3 = 10000

CV3 = 20000

P1, P2, P3, C1, C2, C3, PV1, PV2, PV3, CV1, CV2, CV3 >= 0

b) Spreadsheet model and solution using Solver is following:

Q fx -SUMPRODUCT(E7:E8,H2:H3)+SUMPRODUCT(E12:E13,12:13) G H Peanuts Baking ired (grams) hrs HoldingInitial cost invento 10000

FORMULA VIEW:

1 Demand Month 1 Month2 Month3 Peanuts required (grams) Bakin 60 40 2 Peanut Power 30000 3 Peanut Crunch 80000 40000 0.01 0.0

Q fx SUMPRODUCT(E7:E8,H2:H3)+SUMPRODUCT(E12:E13,12:13) Month3 Peanuts required (grams) Baking hrs Cost Holding cost 0.01 0.01

Total cost = $ 870,667

Add a comment
Know the answer?
Add Answer to:
13. Carter Inc. is planning to launch an energy har in two flavors, demand of which...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 7-13 “Gamma Company has six units of inven- 7 tory, two purchased for $4 each and...

    7-13 “Gamma Company has six units of inven- 7 tory, two purchased for $4 each and fourg purchased for $5 each. Thus, the weighted- j average cost of the inventory is ($4 + $5) = 2 = 1 $4.50 per unit.” Do you agree? Explain. Uly systems. 7-34 Valui A valuing Inventory and Cost of Goods Sold Metals. Ltd., had the following inventory transactions during the month of March (in Crowe Metals, Ltd. British pounds, £): 3/1 beginning inventory Week...

  • 1) (25pts) An engineer is making aggregate planning for the next 4 months. Demand forecasts in...

    1) (25pts) An engineer is making aggregate planning for the next 4 months. Demand forecasts in aggregate items are 600, 350, 400, 700 for months 1 to 4. The company has an initial workforce of 80 and capacity can be adjusted by hiring (at a cost of 150 liras per worker) or firing (at a cost of 900 liras per worker). Each worker is capable of producing 0.2 aggregate items in one workday. The available workdays are given as 25,...

  • Carter Corporation prepares its master budget on a quarterly basis. The following data have been assembled...

    Carter Corporation prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the second quarter of 2019: Actual sales for March and budgeted sales for the next four months are as follows: a. March $120,000 150,000 160,000 100,000 110,000 April Мay June July b. The company's gross profit rate is 44 percent of sales. c. Monthly expenses are budgeted as follows: salaries and wages, $12,000 per month;...

  • Carter Corporation prepares its master budget on a quarterly basis. The following data have been assembled to assi...

    Carter Corporation prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the second quarter of 2019: a. Actual sales for March and budgeted sales for the next four months are as follows: March April May June July $120,000 150,000 160,000 100,000 110,000 b. The company's gross profit rate is 44 percent of sales. c. Monthly expenses are budgeted as follows: salaries and wages, $12,000 per month;...

  • SYNOPSIS The product manager for coffee development at Kraft Canada must decide whether to introduce the...

    SYNOPSIS The product manager for coffee development at Kraft Canada must decide whether to introduce the company's new line of single-serve coffee pods or to await results from the product's launch in the United States. Key strategic decisions include choosing the target market to focus on and determining the value proposition to emphasize. Important questions are also raised in regard to how the new product should be branded, the flavors to offer, whether Kraft should use traditional distribution channels or...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT