Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the Excel Solver Printouts that follow to answer the questions below: Calista's Bakery makes two types of cookies which are sold to Doggie

image text in transcribed

Use the Excel Solver Printouts that follow to answer the questions below: Calista's Bakery makes two types of cookies which are sold to Doggie Day Care centers in Greensboro. Both are sold in two pound bags. Both the Pumpkin Bars and the Carob Bars have a per unit profit of $5.00. The cookies have different requirements for ingredients. The Pumpkin Bars use 1 pound of flour and 4 cups of oatmeal per batch. The Carob Bars require 2 pounds of flour, 3 cups of oatmeal. She has 40 pounds of flour and 20 cups of oatmeal available. Calista is concerned about the proper product mix for the cookies and has instructed her marketing manager, Izabella to determine the optimal product mix. Izabella, who took a Management Science course, created a linear programming model and ran it in Excel Solver (she defined X1 as the number of bags of Pumpkin Bars and X2 as the number of bags of Carob Bars). Use the Excel Solver Results to answer the following questions about this problem. Microsoft Excel 14.0 Answer Report Objective Cell (Max) Cell Name Original Value Final Value Objective Function $B$12 X1 160 160 Variable Cells Cell Name Original Value Final Value Integer $B$10 X1 (Pumpkin Bars) $C$10 X2 (Carob Bars) 24.00000 8.00000 24.00000 Contin 8.00000 Contin Constraints Cell Name Cell Value Formula Status Slack $B$15 LHS 40 $B$15

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: John J. Wild, Ken W. Shaw

2010 Edition

9789813155497, 73379581, 9813155493, 978-0073379586

More Books

Students also viewed these Accounting questions