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

Consumption, (40 points) Consider two consumers, A and B. A and B both want...

(40 points) Consider two consumers, A and B. A and B both want perfect consumption smoothing (c = cf) and both have no current wealth. However, the two consumers have different inc

Classical model and the long-term phillips curve, Q. Classical model and th...

Q. Classical model and the long-term Phillips curve? In classical model, L and real wage are determined from equilibrium conditions in the labor market. L and W/P, hence, are o

What is the marginal product, What is the marginal product? The margina...

What is the marginal product? The marginal product of an input is the extra quantity of output which is generated by using one more unit of which input. Marginal product of

Economics, n 2013, approximately 58 percent of the adult population (245 mi...

n 2013, approximately 58 percent of the adult population (245 million) was employed, the lowest employment rate in 20 years. If the employment rate increased to the prerecession l

Highest willingness to pay, Since anyone is able to obtain a license, not n...

Since anyone is able to obtain a license, not necessarily the low cost suppliers of archery lessons, and it is not necessarily the individuals with the highest willingness to pay w

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

Real GDP using chained-dollar method, 2012 Mangoes 91 boxes $7 a box ...

2012 Mangoes 91 boxes $7 a box Pinapples 56 boxes $12 a box 2013 Mangoes 108 boxes $14 a box Pinapples 70 boxes $8 a box Real GDP in 2013 using the chained-dol

Aplia Chapter Questions, Need answers for the questions (Chapters 10, 11 & ...

Need answers for the questions (Chapters 10, 11 & 12) Please see attached questions. Thanks!

Price of steel jumped, Your firm usually uses about 200-300 tons of steel p...

Your firm usually uses about 200-300 tons of steel per year. Last year, you purchased 100 tons of steel than needed (at a price of $200 per ton) In the meantime, the price of steel

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