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

Intertemporal choices , ) Consider an economy where individuals live for 2 ...

) Consider an economy where individuals live for 2 periods and have prefer- ences represented by ln(c) + ß ln(c') where c and c' represent consumption in the first and second perio

Marginal product of labor and marginal product, How Walmart''s marginal pr...

How Walmart''s marginal product labor related to its marginal product?

Newspaper vending machines, Newspaper vending machines are designed so that...

Newspaper vending machines are designed so that once you have paid for one paper; you have access to all the papers in the machine and could take multiple papers at a time. However

What is independent monetary policy, What is independent monetary policy ...

What is independent monetary policy Advantages: First, in a freely-floating exchange rate, the exchange rate must move down or up to correct a payments imbalance. Second, monet

Define political power and administrative power, Economics Please Help! Ass...

Economics Please Help! Assume that two power plants, Firm 1 and Firm 2, release sulfur dioxide (SO2) in a small urban community that exceeds the emissions standard. To meet the sta

Two evils of monopoly, A government purchase real GDP. Are increases in gov...

A government purchase real GDP. Are increases in government purchases associated with increases in real GDP?Describe the important characteristics of perfect competition and monopo

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

Multiple expansion in banking, Multiple Expansion We have seen that a s...

Multiple Expansion We have seen that a single bank in a banking system can lend rupee for rupee with its excess reserves. What is the lending ability of the commercial banking

Action result in a deadweight loss, The short-run supply of a certain crop ...

The short-run supply of a certain crop is perfectly inelastic, because it has already been harvested and no more of it can be grown until the next growing season. In order to raise

Advantage and disadvantage of outsourcing, What are the pros and cons of ou...

What are the pros and cons of outsourcing in order to keep prices down?

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