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

Explain function of AS-AD model, Q. Explain function of AS-AD model? Th...

Q. Explain function of AS-AD model? The function of AS-AD model is to extend IS-LM model so that we can analyze situations where Y > Y OPT . To achieve this, we should make P e

Mba, Consider the following: The city council has just approved the constru...

Consider the following: The city council has just approved the construction of a water park in your town. You are responsible for studying the impact of the new water park on the l

Deceased relative at zero prices, Kennesaw University Professor Frank A. Ad...

Kennesaw University Professor Frank A. Adams III and Auburn University Professors A. H. Barnett and David L. Kaser man recently estimated the effect of legalizing the sale of cadav

Relation between nominal interest rate and inflation, Relation between nomi...

Relation between nominal interest rate, real interest rate and inflation If we denote the nominal interest rate by R, the real rate by r and the expected inflation by p e then

United states postal service, The United States postal service report 95% o...

The United States postal service report 95% of first class mail within the same city is delivered within two days of the time of mailing. Six letters are randomly sent to different

Production function stuff, 1. Given the following production function: ...

1. Given the following production function: Y = K1/4 L3/4 Find the following: a. Per worker production function. b. Steady-state capital-labor ratio as a function of d and

Economics, The Neoclassical thinking that assumes that all firms are establ...

The Neoclassical thinking that assumes that all firms are established with the intention of making profit has been challenged by the managerial discretion models. How successful ha

Relation between poverty and growth, what is the relationship betwen growth...

what is the relationship betwen growth and poverty? either it is positive or negative?

What is money and what is not money, Q. What is money and what is not money...

Q. What is money and what is not money? If you are trying to conclude if something is money, basically consider whether it would be accepted in most stores as payment. Then you

Filbert and lychee have convex, Filbert and Lychee have convex indifference...

Filbert and Lychee have convex indifference curves. Note Filbert is indifferent between baskets (3, 2) and (4, 1)--these are x, y coordinates. Lychee is indifferent between baskets

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