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

Baumal''s sales revenue maximizaion mode4l, Revenue Maximisation Assignment...

Revenue Maximisation Assignment Help Objectives of the Firm - Baumol''s Model of Sales Revenue Maximisation Baumol''s Model of Sales Revenue Maximisation Baumol presented sales r

How firm produce an output, A firm sells its product in a perfectly competi...

A firm sells its product in a perfectly competitive market where other firm charges a price of $90 per unit. The firm's total costs are C(Q) = 50 + 10Q + 2Q2. How much output shoul

Analyse manipulating monetary policy, Buckley (2009) writes that the UK was...

Buckley (2009) writes that the UK was in recession for several short periods during this time, which placed further emphasis on researchingrelationships between the price of oil an

Protectionisms, definition, argument to protectionism and argument against ...

definition, argument to protectionism and argument against protectionisms

Case fair Oster, iN BOTH CITIES, AN INCREASE IN INCOME COMBINED WITH EXPECT...

iN BOTH CITIES, AN INCREASE IN INCOME COMBINED WITH EXPECTATIONS OF A STRONG MARKET SHIFTED DEMAND AND CAUSED PRICES TO RISE RAPLIDLY DURING THE MID-TO LATE 1980S. Illustrate with

Cost of raw materials annually, If you have $10,000 to start a lawn-cutting...

If you have $10,000 to start a lawn-cutting business, the interest rate is 6 percent, your annual cost of raw materials are $4,000, and the earnings you sacrifice from working at a

How does outsourcing affect the economy, In principle, outsourcing makes th...

In principle, outsourcing makes things a little inexpensive and enhance profitability. Though, some things require to be done 'in house'. For example, some employers (largely) outs

Classical labour market, effects of real wage existing in the market that i...

effects of real wage existing in the market that is lower than the equlibrium real wage.what will happen in this labour market if it is perfectly competitive

What are forms of price floors to lead inefficiency, What are forms of pric...

What are forms of price floors to lead inefficiency? Price floors frequently lead to ineffectiveness in the forms of: a. Inefficient allocation of sales in between sellers

Explain the economic functions of money - a unit of account, Explain the Ec...

Explain the Economic functions of money - A unit of account In a monetary economy, all prices may be expressed in monetary units which everyone may relate to. Without money,

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