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

Various control variables in the data set, From stock and Watson 3rd editio...

From stock and Watson 3rd edition introduction to econometrics Using the data set Teaching Ratings described, carry out the following exercises. a) Run a regression of Course

Standard model, Please explain each of the following terms and explain how ...

Please explain each of the following terms and explain how each is used in the standard model. 1. Iso value line's 2. Production possibilities frontier 3. Indifference curve. You w

New screening methods adopted price do you exect prevail, You are the manag...

You are the manager of an organization in America that distributes blood to hospitals in all 50 states and the District of Columbia. A recent report indicates that nearly 50 Americ

Define ndp, The following is the information from the national income accou...

The following is the information from the national income accounts for a hypothetical country: GDP

Grocery store buys milk, Suppose that a grocery store buys milk for $2.10 a...

Suppose that a grocery store buys milk for $2.10 and sells it for $2.60. If the milk gets old then the grocery store can sell their unsold milk back to their wholesaler for $0.60 (

Tax credit, Suppose that an investment tax credit is stated to be temporary...

Suppose that an investment tax credit is stated to be temporary in nature, and the credit will be 10% on newly acquired capital (investment) equipment and will last just one year o

What are the important tools to consider monetary policy, What are the impo...

What are the important tools to consider Monetary Policy? Important tools to consider Monetary Policy: a. What the money demand curve is b. Why the liquidity preference m

Diversify the business of firm a, The managers of Firm A recommend that Fir...

The managers of Firm A recommend that Firm A purchase Firm B because the purchase will diversify the business of Firm A. Diversification of risks is a desirable strategy for indivi

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