What financial and ethical considerations should be made

Assignment Help Business Economics

Reference no: EM132682943

Question 1. Solve the following problem to find the maximum profit by creating a spreadsheet and using Solver.
A company is making Sofas and Love Seats. The sofa's profit is $1,000 and the love seats profit is $950.
There are 2 factories available to make the products.
Factory 1 requires 55 hours to make a sofa and 40 hours to make a love seat. It has 6,000 hours available.
Factory 2 requires 50 hours to make a sofa and 45 hours to make a love seat. It has 4,000 hours available.
Factory 1 needs at least 3 employees for a sofa and
2 employees for a love seat. The total minimum required is 80.
Factory 2 needs at least 2 employees for a sofa and
3 employees for a love seat. The total minimum required is 45.
The company is also willing to offer coupons to customers. The coupons can be redeemed for $25 off a sofa or $20 off a love seat. The total redemption of the coupons equals $1,800.
The maximum number of sofa's that can be produced is 75.

Case Review (answer on a Word document)
Company guidelines state that a project should not move forward if profit is less than $100,000.
Based on the results of your excel calculations, should you go forward with this project?
a. Not going forward with the project means that 15 employees will be laid off for up to 6 months. The cost of unemployment, rehiring or hiring and training new replacement employees is approximately $7,000 per position. Does this information change your decision to move forward with this project?
b. What financial and ethical considerations should be made?

Question 2. Solve the following problem to find the maximum profit by creating a spreadsheet on another tab of the spreadsheet from above.
A company is making Boats and Motors. The boats sell for $22,000 and the motors sell for $15,000.
There are 3 factories available to make the products.
Factory 1 requires 9 hours to make a boat and is not capable of making motors. It has 84 hours available.
Factory 2 does not have the capability to make boats and requires 3 hours to make a motor. It has 40 hours available.
Factory 3 requires 16 hours to make a boat and 5 hours to make a motor. It has 120 hours available.

Reference no: EM132682943

Questions Cloud

Discuss the importance of the balance of payments : Discuss the current account and its components and the capital and financial accounts and their components. Discuss the importance of the balance of payments

Give an example about the way banks make disclosure : Unimpaired loans, so explain and give an example about the way banks make disclosure on credit portfolios. Give the name of the bank you have chosen.

What is the growth prospects for the companies : What is the growth prospects for the companies and which company is a better investment to add to an investment portfolio and why?

How much in resources does hobo have to work with : How much of the company's assets do the Hobo stockholders actually own? How much in resources does Hobo have to work with?

What financial and ethical considerations should be made : What financial and ethical considerations should be made and Does this information change your decision to move forward with this project?

Write doughnuts accounting equation : Current liabilities are $170 million and long-term liabilities total $300 million. Use these data to write Doughnuts' accounting equation.

Find what is the owner equity at the end : During the year, assets increased by $40,000 and liabilities decreased by $15,000. What is the owner's equity at the end of 2019?

Write a short memo to kaylee offering : Kaylee James opened Kaylee Sweets on January.Write a short memo to Kaylee offering your opinion on the results of operations during the first month of business.

Find the income statement for each company : Find the income statement for each company (2016 Merck; Novartis PDF files above). Enter in the net income for each company

User Account

All Pages