BA 340 Financial and Managerial Accounting Final EXAM

Financial and Managerial Accounting Final EXAMInstructions: This final exam is open book/open notes. The use of calculators and spreadsheets (of course) is permitted.Working in teams is not permitted. If you have any questions, please post on Moodle.This exam has 9 sections Break-even with Opportunity CostsCost BehaviorMultiple Product Break-evenNPVSunk CostsDeath Spiral 20%20%20%20%10%10%100% Assume a local gluten-free pizzeria, on Harrison street, reported the following results for June and JulyJuneJulyUnit Sales2,5002,900Cost of Food SoldWages and SalariesRentDepreciationUtilitiesSuppliesTotal $ 5,0003,7002,0005001,400500$ 13,100 $ 5,8004,0002,0005001,500540$ 14,340 a. Identify each cost as being fixed, variable or mixed.b. Determine the equation for total operating costs (Fixed + Unit Variable Cost * # of pizzas)c. Predict the total operating costs for3000 pizzasd. Determine the average costs for3000 pizzas Cruisin’ with Lincoln AlumniAfter successfully earning a MBA, Lincoln alumni decide to form their owncruise ship company based out of San Francisco. Lincoln Alumni cruises offers luxury trips along the Pacific Coastand to the Hawaiian Islands. They are debating what to do with their existing ship, S.S.Mission Bay which was built 15 years ago for $90 M and is now fully depreciated. To replace the Mission Baywould cost $180M and its current market value is $150M. Lincoln Alumni Cruises’ cost of capital is 15%.Lincoln Alumni, dusting off some accounting materials, were able to determine the operating costsfor a two-week cruise to Alaska, which would be a change from a three week cruise from travelling down toGuatemala. Here are their estimates (based on 2,000 passengers per cruise and 25 cruises per year): PER CRUISELaborFoodFuelPort fees and servicesMarketing, ads, promotionSuppliesTotals Variable Costs Fixed Costs750,000150,000750,00075,000650,000125,000350,000500,000150,0002,000,0001,500,000 a. Assuming that the two-week Alaskan cruise will be priced at $3,000 per passenger, please calculatethe break-even number of passengers per cruise based on the data above.b. What do the Lincoln Alumni need to consider beyond these estimates, and if they included this consideration,what would happen to the break-even point? Would there be an issue if the max capacity of the ship was 1,150 passengers? Name: Sevall Surfware is a company that specializes in selling towels, swimsuits, and beach accessories.The sales mix is 5:5:10 (i.e. for every 5 towels sold, 5 swimsuits and 10 beach accessories are sold).Find the break-even point for each product. The company’s annual fixed costs are 68,000Additionally, Sevall wants to achieve an operating profit of $136,000. How many units would it need to sell to achieve a profit of $136K? TowelsSwimsuitsBeach Accessories SellingVariablePrice Per Cost PerUnitUnit20650203018 Fixing our EnvironmentExternality enterprises are contemplating how to react to California regulations regarding their proposed oil refinery in Redwood City.They face two options. Under option A, the initial investment would cost $0.8B ($800M) to build without fully meeting regulatory requirements. The unit price and variable costper barrel of this product is estimated to be $150 and $100 respectively. While California would permit this facility to be built, Externality would have to pay a penalty of $15M per year after taxes. Under Option B, the initial outlay for the oil refinery would triple to $2.4 B ($2,400M). However, with the added cost, there would be improvements with regard to increased operating efficiencies and perceived quality.Estimates suggest that the variable cost per barrel of product would be reduced to $75 and the price that Externality could charge customers would be raised to $200 per barrel.Lastly, there would not be the annual $15M fee imposed by the State of California. Under both conditions, they would expect to produce and sell 5 million barrels per year. Additionally, the initial investment would be expected to have a useful life of 20 years,without any salvage value at the end of the 20 years; for depreciation purposes, straight-line depreciation would be used.The tax rate is 40% and the cost of capital is 16% for both options. Lastly, the pricing, variable costs and demand levels are estimated to be constant for the next 20 years. Which option should Externality choose that would maximize Externality’s financial value? How did the California penalty ($15M annually) affect your recommendation?Please support your recommendation with a Net Present Value calculation using discounted cash flow analysis.(A suggestion: keep your answers in the millions—don’t get wrapped up around all the zeros; also, you may want to look at 3-33 and 3-35 as this problem is a blend between the two). Industrial GrindersDuring the term, we had a case study, Industrial Grinders, which focused on Sunk and Opportunity Costs.Please refer to the table below, which comes from data in the Industrial Grinders case Selling Price Competitor 100Plastic Rings$320.40 CostsDirect Material$Direct LaborOverheadDepartmentalAdministrativeTotal Manufacturing Cos $ 4.2015.6031.2015.6066.60 Industrial Grinders 100Steel Rings (Finished)$320.40 $ $ Industrial Grinders100 Steel Rings(Unfinished orSpecialized Steel) 76.6546.8093.6046.80263.85 Regarding the Overhead costs, these are allocated based on Direct Labor;The Variable Overhead costs are 80% of the Direct Labor amount, and relate to the benefitsfor the labor force. As you recall from the case, Industrial Grinders has the opportunity to hire the German Labor Forceat a rate of 70% of the normal rate. What would be the RELEVANT costs for Decision-Makingto produce the UNFINISHED (or Specialized Steel) to FINISHED steel? Please indicate your answers in the YELLOW boxabove.Also, what PRICE POINT would the customer expect to see for the Steel Rings given that the Competitors Plastic Ringslast FOUR times as long? Please indicate in the YELLOW BOX in Cell E9.Lastly, briefly comment on whether it would be cheaper to produce the Plastic Rings or to hire the German Labor from aRELEVANT COST perspective. No more than two sentences are required. ortunity Costs. ur answers in the YELLOW boxes he Competitors Plastic Rings re the German Labor from a Death Spiral and Opportunity CostsIn addition to Professor’s On Call, Dan owns a video shop in San Francisco. He is considering dropping a line of videos (comedies), which has consistently had an operating loss.Below are the income statements for Dan’s three lines of videos:TotalSalesVariable CostsContribution MarginFixed CostsOperating Income 7,7004,8002,9002,250650 DramaActionComedy5,0001,9008003,5001,0003001,500900500750750750750150(250) Fixed costs relate to the amount of space that is used in the video store. Given constraints on his ability to sell videos, Dan cannotuse this space for anything else. In other words, Dan can only sell videos and can’t use the space for other things.Should Dan close the comedy section? Support your answer with calculations and discussion.Now, suppose that if he replaced the comedy with additional drama or action, he could get $1,000 in additional drama or action revenue. The contribution marginpercentages would be the same as in the first case. Using opportunity cost concepts, should Dan replace comedy with either drama or action films?