The Auto Company of America (ACA) produces six types of vehicles; which includes four styles of cars: subcompacts, compact, intermediate, and luxury; as well as trucks and vans. Vendor capacities limit total production capacity to, at most, 1.2 million vehicles per year. Subcompacts and compacts are built together in a facility with a total annual capacity of 620,000 cars. Intermediate and luxury cars are produced in another facility with a capacity of 400,000; and the truck/van facility has a capacity of 275,000. ACAâs marketing strategy requires that subcompacts and compacts must constitute at least half of the product mix for the four car types. The Corporate Average Fuel Economy (CAFE) standards require an average fleet fuel economy of at least 27 MPG. Profit margins, market potential, and fuel efficiencies are summarized below. Profit Margin ($/vehicle)

Market Potential
(sales in â000)

Fuel Economy
(MPG)

Subcompact15060040
Compact22540034
Intermediate25030015
Luxury50022512
Truck40032520
Van20010025
Construct and solve a Linear Optimization model for this problem in Excel.

For the past six years, the price of slippery rock stock has been increasing at a rate of 8.21 percent a year. currently, the stock is priced at $43.40 a share and has a required return of 11.65 percent. what is the dividend yield? 3.20 percent 2.75 percent 3.69 percent

Kumar consulting operates several stock investment portfolios that are used by firms for investment of pension plan assets. last year, one portfolio had a realized return of 12.6 percent and a beta coefficient of 1.15. the average t-bond rate was 7 percent and the realized rate of return on the s& p 500 was 12 percent. what was the portfolio's alpha?

Laval produces lamps and home lighting fixtures. its most popular product is a brushed aluminum desk lamp. this lamp is made from components shaped in the fabricating department and assembled in the assembly department. information related to the 22,000 desk lamps produced annually follows.direct materials $280,000direct labor fabricating department (8,000 dlh × $24 per dlh) $192,000assembly department (16,600 dlh × $26 per dlh) $431,600machine hours fabricating department $15,200mhassembly department $20,850mhexpected overhead cost and related data for the two production departments follow.fabricating assemblydirect labor hours 150,000dlh 295,000dlhmachine hours 161,000mh 128,000mhoverhead cost $400,000 430,000required1. determine the plantwide overhead rate for laval using direct labor hours as a base.2. determine the total manufacturing cost per unit for the aluminum desk lamp using the plantwide overhead rate.3. compute departmental overhead rates based on machine hours in the fabricating department and direct labor hours in the assembly department.4. use departmental overhead rates from requirement 3 to determine the total manufacturing cost per unit for the aluminum desk lamps.