Estimate the maximum possible daily profit, Macroeconomics

Assignment Help:

Shambles have selected the "Mythical Beasts" range and decided to concentrate on "Pegasus" and "Phoenix." They would now like to find the right mix of these two products in order to maximise profit. Each toy has to go through two processes during manufacture: sewing and stuffing.

Pegasus takes 30 minutes to sew whilst Phoenix takes 20 minutes; there are 10 hours (600 minutes) available for sewing each day.

Pegasus takes 20 minutes to stuff whilst Phoenix takes 25 minutes; there are 10 hours (600 minutes) available for stuffing each day.

Pegasus generates £4 profit per toy whilst Phoenix generates £5 profit per toy.

What is the maximum possible daily profit, and how many of each product should be produced in order to achieve this?

Use "Solver" in Microsoft Excel to solve this problem. Include:

a print-out of cell values
a print-out of cell formulae
a print-out of the Solver dialogue box with optimisation conditions and constraints
an Answer Report from Solve
a statement of the answer in words

 


Related Discussions:- Estimate the maximum possible daily profit

Expect to affect economic growth and wealth, Despite the economic progress ...

Despite the economic progress that the U.S. has observed in the past century, the standard of living remains extremely low in many countries. Why are some countries relatively weal

Consumer increases her purchases of compact disks, Suppose a consumer's inc...

Suppose a consumer's income increases from $30,000 to $36,000. As a result, the consumer increases her purchases of compact disks (CDs) from 25 CDs to 30 CDs. What is the consumer'

Percentage did the price level, By what percentage did the price level, as ...

By what percentage did the price level, as measured by this index, rise between 1984 and 2005?

Demand for green and chai tea, Given the data in the table below, provide a...

Given the data in the table below, provide an estimate of the arc price elasticity of demand for green and chai tea. Chai tea Price $/lb. 10.4, 10.5 Chai tea Quantity mil lbs. 75

Critique the effectiveness of the model, Discuss how decisions are made in ...

Discuss how decisions are made in your workgroup. Which model is used for what situation? Be sure to provide specific examples of at least three situations and what model was used

Set up a diagram.., (a) Use this information to set up a diagram showing th...

(a) Use this information to set up a diagram showing the firm''s total revenue and total cost schedules. In this diagram, show the points at which the firm is maximizing profits.

The Business Cycle, I would like to know one of the external determinants i...

I would like to know one of the external determinants in Spain''s recovery, please?

MONOPOLY, WHAT ARE THE SOURCES OF MONOPOLY

WHAT ARE THE SOURCES OF MONOPOLY

Output-maximizing model, For a single nonprofit provider, describe an outpu...

For a single nonprofit provider, describe an output-maximizing model to predict supplier behavior.

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd