subject
Business, 10.03.2020 00:49 carter4026

Alan Industries is expanding its product line to include three new products: A, B, and C. These are to be produced on the same production equipment, and the objective is to meet the demands for the three products using overtime where necessary. The demand forecast for the next four months, in hours required to make each product, is:

PRODUCT APRIL MAY JUNE JULY
A 760 560 760 1,160
B 560 660 860 1,090
C 660 460 660 810

Because the products deteriorate rapidly, there is a high loss in quality and, consequently, a high carrying cost when a product is made and carried in inventory to meet future demand. Each hour's production carried into future months costs $3 per production hour for A, $4 for Model B, and $5 for Model C.

Production can take place either during regular working hours or during overtime. Regular time is paid at $4 when working on A, $5 for B, and $6 for C. The overtime premium is 50 percent of the regular time cost per hour.
The number of production hours available for regular time and overtime is:

APRIL MAY JUNE JULY
Regular time 1,460 1,310 1,760 1,970
Overtime 660 610 860 980

Required:
Calculate the objective value using Excel Solver.

ansver
Answers: 2

Another question on Business

question
Business, 21.06.2019 19:20
Which of the following areas provides residents with close access to high-paying jobs and cultural attractions? a. the suburbs b. exurbs c. rural areas d. the city 2b2t
Answers: 3
question
Business, 21.06.2019 21:30
Prepare journal entries for each transaction and identify the financial statement impact of each entry. the financial statements are automatically generated based on the journal entries recorded. apr. 1 tanner invested $80,000 cash along with office equipment valued at $26,000 in the company in exchange for common stock.apr. 2 the company prepaid $9,000 cash for 12 months' rent for office space. the company's policy is record prepaid expenses in balance sheet accounts.apr. 3 the company made credit purchases for $8,000 in office equipment and $3,600 in office supplies. payment is due within 10 days.apr. 6 the company completed services for a client and immediately received $4,000 cash.apr. 9 the company completed a $6,000 project for a client, who must pay within 30 days.apr. 13 the company paid $11,600 cash to settle the account payable created on april 3.apr. 19 the company paid $2,400 cash for the premium on a 12-month insurance policy. the company's policy is record prepaid expenses in balance sheet accounts.apr. 22 the company received $4,400 cash as partial payment for the work completed on april 9.apr. 25 the company completed work for another client for $2,890 on credit.apr. 28 the company paid $5,500 cash in dividends.apr. 29 the company purchased $600 of additional office supplies on credit.apr. 30 the company paid $435 cash for this month's utility bill.
Answers: 3
question
Business, 22.06.2019 00:30
Aprice ceiling is “binding” if the price ceiling is set below the equilibrium price. suppose that the equilibrium price is $5. if a price ceiling is set at $6, this will not affect the market in any way since $5 remains a legally allowable price (since $5 < $6). a price ceiling of $6 is called a “non-binding” price ceiling. on the other hand, if the price ceiling is set at $4, the price ceiling is “binding” because the natural equilibrium price is $5 but that is no longer allowed. what happens when there is a binding price ceiling? at a price below the equilibrium price, quantity demanded exceeds quantity supplied. there is a shortage. normally, price increases eliminate shortages by increasing quantity supplied and decreasing quantity demanded. in this case, however, price increases are not allowed past the price ceiling. we therefore predict that the observed market price will be right at the price ceiling and there will be a permanent shortage. the observed quantity bought and sold will be dictated by the quantity supplied at the price ceiling. although consumers would like to buy more, there are no more units for sale
Answers: 1
question
Business, 22.06.2019 02:30
The cost of capital: introduction the cost of capital: introduction companies issue bonds, preferred stock, and common equity to aise capital to invest in capital budgeting projects. capital is』necessary factor of production and like any other factor, it has a cost. this cost is equal to the select the applicable security. the rates of return that investors require on bonds, preferred stocks, and common equity represent the costs of those securities to the firm. companies estimate the required returns on their securities, calculate a weighted average of the costs of their different types of capital, and use this average cost for capital budgeting purposes. required return on rate: when calculating om operations when the firm's primary financial objective is to select shareholder value. to do this, companies invest in projects that earnselect their cost of capital. so, the cost of capital is often referred to as the -select -select and accruals, which a se spontaneously we hted average cost of capital wa c our concern is with capital that must be provided by select- 쑤 interest-bearing debt preferred stock and common equity. capital budgeting projects are undertaken, are not included as part of total invested capital because they do not come directly from investors. which of the following would be included in the caculation of total invested capital? choose the response that is most correct a. notes payable b. taxes payable c retained earnings d. responses a and c would be included in the calculation of total invested capital. e. none of the above would be included in the cakulation of total invested capital.
Answers: 2
You know the right answer?
Alan Industries is expanding its product line to include three new products: A, B, and C. These are...
Questions
question
Mathematics, 20.11.2019 06:31
question
Mathematics, 20.11.2019 06:31
Questions on the website: 13722360