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

Components of trade policy, COMPONENTS OF TRADE POLICY: External secto...

COMPONENTS OF TRADE POLICY: External sector reforms beginning with 1991 included dismantling of  trade restrictions along with tariff rationalization, a move towards current a

Demand, Demand: Demand is quantity of a good buyer who wishes to purcha...

Demand: Demand is quantity of a good buyer who wishes to purchase at each conceivable price. The law of demand explains us that if the price of certain commodity increases,

Describe the short run effect of the supply shock, Question : The long-...

Question : The long-run position of an economy is described by the quantity theory of money: M/P = L (Y, r) Where M: nominal money stock; P: price level; Y: real income a

Determination of variables in as-ad model, Q. Determination of variables in...

Q. Determination of variables in AS-AD model? Once Y and P are determined, all other endogenous variables would be determined as well. Interest rate is determined by money mark

What are the explicit costs, A young chef is considering opening his own su...

A young chef is considering opening his own sushi bar. to do so, he would have to quite his current job, which pays him $20,000 a year , and take over a store building that he owns

EXCHANGE RATES, WHAT IS THE BEST EXCHANGE RATE TYPE

WHAT IS THE BEST EXCHANGE RATE TYPE

Kernel density estimator to plot the two densities, The data is posted on B...

The data is posted on Blackboard. Download the data lfs4.dta on your personal computer. This data is from the Labour Force Survey 2003. In STATA, add enough memory to open the data

Planning activities, What are the different stages of analysis in planning ...

What are the different stages of analysis in planning activities?

Full economic price of this legislation, From California to New York, legis...

From California to New York, legislative bodies across the United States are considering eliminating or reducing the surcharges that banks impose on noncustomers, who make $14 mill

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