You have a nice place in a rural setting with a little kitchen and a few cows out in the back. You figure you can make $4.5 profit per cake (C) that you can bake or $3 profit per dozen cookies (D) you make. The main constraints for you are that you can only use the oven in the kitchen nine hours per day (and the oven will only fit one cake or one dozen cookies at one time), and you can only have 10 pounds of butter per day. Each cake takes 45 minutes to bake and requires one half pound of butter. A dozen cookies require 30 minutes in the oven and one pound of butter.You will want to think about a graph that has cakes on the horizontal axis and dozens of cookies on the vertical axis.What other formulas are used within the excel spreadsheet? E7fr=3*SUM(C3:D3)Solver ParametersAВCFGH1Set Objective:SESTCakesCookies (in dozens)ConstraintO MaxO value Of:Units86To:Min4Oven time4530540 <=540By Changing Variable Cells:Butter0.5110 <=10SCS3:$D$37Profit =42Subject to the Constraints:8SE$4:$E$5 <= $G$4:$G$5Add910Change11Delete1213Reset All1415Load/Save16V Make Unconstrained Variables Non-Negative17Select a SolvingMethod:18Simplex LPOptions1920Solving Method21Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplexengine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are22non-smooth.232425HelpSolveClose

Excel Spreadsheet: The excel spreadsheet is used for creating grids of the numbers, texts, and…

You have a nice place in a rural setting with a little kitchen and a few cows out in the back. You figure you can make $4.5 profit per cake (C) that you can bake or $3 profit per dozen cookies (D) you make. The main constraints for you are that you can only use the oven in the kitchen nine hours per day (and the oven will only fit one cake or one dozen cookies at one time), and you can only have 10 pounds of butter per day. Each cake takes 45 minutes to bake and requires one half pound of butter. A dozen cookies require 30 minutes in the oven and one pound of butter. You will want to think about a graph that has cakes on the horizontal axis and dozens of cookies on the vertical axis. What other formulas are used within the excel spreadsheet?

You have a nice place in a rural setting with a little kitchen and a few cows out in the back. You figure you can make $4.5 profit per cake (C) that you can bake or $3 profit per dozen cookies (D) you make. The main constraints for you are that you can only use the oven in the kitchen nine hours per day (and the oven will only fit one cake or one dozen cookies at one time), and you can only have 10 pounds of butter per day. Each cake takes 45 minutes to bake and requires one half pound of butter. A dozen cookies require 30 minutes in the oven and one pound of butter. You will want to think about a graph that has cakes on the horizontal axis and dozens of cookies on the vertical axis. What other formulas are used within the excel spreadsheet?

A First Course in Probability (10th Edition)

10th Edition

ISBN:9780134753119

Author:Sheldon Ross

Publisher:Sheldon Ross

Chapter1: Combinatorial Analysis

Section: Chapter Questions

Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...

See similar textbooks

Related questions

Q: Julia frequently drinks cups of coffee and tea during the semester. Big World sells coffee for $3.00…

A: (a)If Julia buys cups of coffee at each, she spends on coffee.She has left for tea.With , she…

Q: H. You own a bakery that produces two types of cakes: chocolate cakes and vanilla cakes. You need to…

A: To maximize profit, we need to determine the number of chocolate cakes and vanilla cakes to produce…

Q: Rough Stuff makes 2 products: khaki shorts and khaki pants for men. Each product passes through the…

A: Contribution margin per hour = Contribution margin per unit / Hour per unit

Q: ABC manufacturing has $95 for the sale of sofa bed and $185 for the bed frames. It takes 5 hours to…

A: Operation research

Q: A farmer in the magical land of Avalon is raising a unicorn to sell to a band of Jewel Riders. The…

A: Ques: A farmer in the magical land of Avalon is raising a unicorn to sell to a band of Jewel Riders.…

Q: A company has $14,450 available per month for advertising. Newspaper ads cost $160 each and can't…

A: Step 1: Define the Objective FunctionThe objective is to maximize the number of ad exposures to…

Q: he A Producer of pleasure boats wants to maximize his profits during the next season. Two types of…

A: The question is related to linear programming. We have to formulate the linear programming model.…

Q: Nancy is planning to invest up to $100,000 in corporate and municipal bonds. The least she will…

Q: There are two different styles of shirts UB is planning on selling at the bookstore. UB will pay $12…

A: Let Number of cheaper shirt = x Number of other shirt = y cheaper shirt yields a profit of $8 and…

Q: siness custom-printing replicas of pets and is looking at the costs involved. ce ($600 for rent and…

Q: Succulent Citrus produces orange juice and orange concentrate. This year the company anticipates a…

A: The objective of this question is to determine the number of quarts of orange juice and orange…

Q: A farmer in the magical land of Avalon is raising a unicorn to sell to a band of Jewel Riders. The…

A: Given that, the market price of the unicorn is $12 per pound, rate of fall of price is -0.10 pounds…

Q: Carlo and Anita make mailboxes and toys in their craft shop near Lincoln. Each mailbox requires 1…

Q: You have $300 to spend on a fence. You want to fence in an area that is a rectangle split in two in…

A: NOTE: Refresh your page if you can't see any equations. . x=width of the rectangle y=length of the…

Q: You have $37,000 you would like to invest in two different stocks, Stock Boll and Stock Coff. The…

A: The objective of this question is to determine the optimal investment strategy to maximize annual…

Q: You have $37,000 you would like to invest in two different stocks, Stock Boll and Stock Coff. The…

A: Step-by-Step Calculation to Maximize Interest Earned: Define Variables:Let x be the amount you…

Q: Consider a manufacturing firm that has revenues of $160 per day. The firm must transport its output…

A: a) To find the firm's maximum willingness to pay per hectare of land at the central freight terminal…

Q: A farmer has 10 acres available to plant purple potatoes and russet potatoes. Each acre of purple…

A: Assume in x acres farmer has planted purple potatoes and in y acres he has planted russet potato.

Q: Ask

A: A farmer in the magical land of Avalon is raising a unicorn to sell to a band of Jewel Riders. ne…

Q: You are designing a rectangular window, and are given $240. The bottom side of the window (the sill)…

Q: Micah's gym is moving into a bigger space, where he can have more stationary bicycles and treadmills…

Q: PROBLEM OF THE WEEK Someone is opening their own funeral home business. They know that money will be…

A: First, we need to calculate the total expenses for the year. This includes the cost of the building…

Q: Consider a random variable Y with density function given by f(y) = ke¬v³ /20, –∞ < y < oo. a) Find…

Question

The main constraints for you are that you can only use the oven in the kitchen nine hours per day (and the oven will only fit one cake or one dozen cookies at one time), and you can only have 10 pounds of butter per day. Each cake takes 45 minutes to bake and requires one half pound of butter. A dozen cookies require 30 minutes in the oven and one pound of butter.

You will want to think about a graph that has cakes on the horizontal axis and dozens of cookies on the vertical axis.

What other formulas are used within the excel spreadsheet?

E7
fr
=3*SUM(C3:D3)
Solver Parameters
A
В
C
F
G
H
1
Set Objective:
SEST
Cakes
Cookies (in dozens)
Constraint
O Max
O value Of:
Units
8
6
To:
Min
4
Oven time
45
30
540 <=
540
By Changing Variable Cells:
Butter
0.5
1
10 <=
10
SCS3:$D$3
7
Profit =
42
Subject to the Constraints:
8
SE$4:$E$5 <= $G$4:$G$5
Add
9
10
Change
11
Delete
12
13
Reset All
14
15
Load/Save
16
V Make Unconstrained Variables Non-Negative
17
Select a Solving
Method:
18
Simplex LP
Options
19
20
Solving Method
21
Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex
engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are
22
non-smooth.
23
24
25
Help
Solve
Close

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

You have $37,000 you would like to invest in two different stocks, Stock Boll and Stock Coff. The buying limit on Stock Coff is $12,900 and you want to spend at least two times as much money on Stock Boll as Stock Coff. If Stock Boll earns 5% annual interest and Stock Coff earns 4% annual interest, how much money (in dollars) should you invest in each stock to maximize your annual interest earned? What is the maximum annual interest (in dollars)? You will earn a maximum total annual interest of $ if you invest $ in Stock Boll and $ in Stock Coff.
sara plans to sell two types of CD players at costs of $275 and $400. the $275 model yields a profit of $55 and the $400 model yields a profit of $75. She estimates that the total monthly demand will not exceed 300 units. Sara does not want to invest more than $100000 in inventory for these products. What is the maximum profit?
Succulent Citrus produces orange juice and orange concentrate. This year the company anticipates a demand of at least 12,000 quarts of orange juice and 1,500 quarts of orange concentrate. Each quart of orange juice requires 10 oranges, and each quart of concentrate requires 50 oranges. The company also anticipates using at least 270,000 oranges for these products. Each quart of orange juice costs the company 50¢ to produce, and each quart of concentrate costs $2.00 to produce. How many quarts of each product should Succulent Citrus produce to meet the demand and minimize total costs? orange juice qt qt orange concentrate
A farmer in the magical land of Avalon is raising a unicorn to sell to a band of Jewel Riders. The market price for unicorn is $12 per pound, but is falling 10 cents per day. The rapidly growing unicorn is currently weighing 400 pounds and is expected to gain 5 pounds per day for the next two to three weeks. The costs to raise a typical unicorn are $5 per day plus $100 for a special unicorn harness and feedbag. What is the optimal time to sell the unicorn to the Jewel Riders? I need to use the Five Step Method for mathematical modeling. Ask the Question. The Question must be phrased mathematically and object must be stated in precise mathematical terms. List all variables and assumptions you are making about them. Do not confuse variables with constants in the problem. Check units for consistency. Select a modeling approach. This could be optimization in one or more variables, linear programming, or many other approaches available in the field of math. Formulate the model. Restate…
Carlo and Anita make mailboxes and toys in their craft shop near Lincoln. Each mailbox requires 4 hours of work from Carlo and 4 hours from Anita. Each toy requires 2 hours of work from Carlo and 4 hours from Anita. Carlo cannot work more than 16 hours per week and Anita cannot work more than 20 hours per week. If each mailbox sells for $9 and each toy sells for $13, then how many of each should they make to maximize their revenue? What is their maximum revenue? ---- Carlo and Anita should make mailboxes and toys. Their maximum revenue is $
Mr. Tran has $27,000 to invest, some in bonds and the rest in stocks. He has decided that the money invested in bonds must be at least twice as much as that in stocks. But the money invested in bonds must not be greater than $19,200. If the bonds earn 5%, and the stocks earn 8%, how much money should he invest in each to maximize his interest earned??
Nannette Specialties is a family-style restaurant providing food trays and packed meals. Nannette, being the owner of the food business feels worried about the significant cost incurred every time customer waits. She estimated that the cost incurred for every minute a customer spends in the restaurant is $0.50. The average capacity that the restaurant can accommodate is 12 customers per minute only, considering both the waiting and service time. Nannette now considering employing additional servers for her restaurant. Provided with the cost of service if hiring 7 servers incurs cost $18 to $126, and the average customer waits served by a server alone starts from 7 minutes, 6, 5, 4 and so on. Given this cost, how much is the total expected cost? how many servers should Nannette employ?
You have a nice place in a rural setting with a little kitchen and a few cows out in the back. You figure you can make $4.5 profit per cake (C) that you can bake or $3 profit per dozen cookies (D) you make. The main constraints for you are that you can only use the oven in the kitchen nine hours per day (and the oven will only fit one cake or one dozen cookies at one time), and you can only have 10 pounds of butter per day. Each cake takes 45 minutes to bake and requires one half pound of butter. A dozen cookies require 30 minutes in the oven and one pound of butter.You will want to think about a graph that has cakes on the horizontal axis and dozens of cookies on the vertical axis.Your objective is to maximize profit from cakes and dozens of cookies per day c State which corner(s) of the feasible region is the optimal solution and what is the value of profit at that point(s). e. Are there alternative optimal solutions here? Why or why not?
A farmer in the magical land of Avalon is raising a unicorn to sell to a band of Jewel Riders. The market price for unicorn is $12 per pound, but is falling 10 cents per day. The rapidly growing unicorn is currently weighing 400 pounds and is expected to gain 5 pounds per day for the next two to three weeks. The costs to raise a typical unicorn are $5 per day plus $100 for a special unicorn harness and feedbag. What is the optimal time to sell the unicorn to the Jewel Riders? P(x)= -.5x2+15x+4700 P'(x)= -x+15 p"(x)= -1 < 0 SENSITIVITY ANALYSIS: (This is the part I am a bit uncertain about. The questions below.) Any help is much appreciated. 1. Preform a sensitivity analysis of the optimal time to sell versus the variable cost to raise a unicorn (harness still $100). 2. So if the actual variable cost was $4.00 per day instead of $5.00 (20% decrease), what would you estimate for the best time to sell based on your sensitivity results? 3. Finally, substitute $4.00 for the variable…
You want to build a 1200 square foot rectangular infinity pool. Three of the sides will have regular pool walls, and the fourth side will have the infinity pool wall. Regular pool walls cost $15 per foot (regardless of how deep the pool is), and the infinity pool wall costs $35 per foot (regardless of depth). How long should you make the infinity wall so that you minimize your costs?