Introduction Matthew Cox, a thirdegeneratlon producer of eggs based in the small town of Pickton, Texas, converted production in 2019 from conventional caged white eggs to specialty eggs. His company is called Pickton Egg Company lPEC). PEC has a total of 230,000 hens with a contract to produce organic cage-free [OCF] eggs. It was early September of 2023 and the retail specralty egg market, which included cage7free, was weak, mostly due to an oversupply of conventional caged white eggs. Conventional caged eggs were a commodity and producer prices were sensitive to shifts in supply and demand, But specialty Eggs were often grown under contracts that protected producers. This differential had gotten so large that consumers of specialty eggs were switching back to conventional eggs, Until now, his margins on production had been largely protected by a contract that guaranteed a fix price purchase, but that contract would expire soon, and Cox would be competing in the open market for egg prices that were now a fraction of his production costs, Cox wondered how he could protect his investment and minimize his Fosses, Cost Structure at PEC PEC uses the Hylrne Brown breedcommercial layers that will lay 26 to 28 dozen eggs in their lifetime. He gets them from the hatchery at $0.95. By 24 weeks, when they really start laying, there is a pre production cost, The costs are provided in the table below, The profit margins are estimated conditioning that PEC sells on this year's contract, Without the contract, Cox would have to sell eggs on the open market where brown eggs were trading at 65 cents per dozen. In the current contract, the price of cagefree eggs is $1.9 per dozen. Variable .roduction costs feed, trans-ortation, labor, etc] 530.32 Outionol: Or-onic Feed 5015 On average, peak hen egg production occurred around week 35 and decreased thereafter. Hens "productive" for 55 weeks beginning with week 24 (table below), when the hens were \"spent" LE. not producing many eggs, but they were still consuming the same amount of food and thus it was no longer financially feasible to keep the hens alive. When the hens were spent, the layer house was \"depopulatecl," costing 15 cents per hen, and the house was readied for the next flock. Currently, the farms' contract ends by week 55. if of eggs per hen per week Page 1 of 2 IE 5304 Advanced Engineering Economy 7 Prof. Mohammadlahanbakht e Unlversny ofTexas at Arlington Questions: 1. Assume that market remains undisturbed and PEC can renew her contract With the same rate. Calculate cumulative fixed cost, variable cost, total cost, total revenue, and total profit for each week he 1778] and draw 3 charts: one that shows Cumulative Fixed Costs, Variable Costs and Total Costs per hen, one that shows Marginal Revenue and Total Revenue (per hen], and one that shows Cumulative Total Cost, Total Revenue and Total Profit (per hen] 2, Now assume that PEC lose contract at the end of week 55 and has no option but to sell eggs in the open market. Repeat alt calculations and charts on question 1. Cox has to make a hard choice to euthanize his hens early. What week should he euthanize to maximize his profit? Would your answer change if the price of open market change from 65 cents to 75 cents? 3. Now assume the market condition is getting worse in 2023. Still, he assessed that there is a 65% chance that he can secure contract for specialty egg but if he can't, he is forced to seil at open market (and accept the loss). Cox has to make a decision whether to revert his farm to a regular (non-specialty) egg production, If he chooses to do so, his cost structure significantly reduce (table below) but he incurs a one-time cost of $250,000, For regular eggs, the current contract price is $0 9 and seems stable at least for the next year. What would you recommend? Do a sensitivity analysis to show your recommendation is robust. Ap estimate posts structure for OCF (if hens are spent on week 78) S / Per Bird Ac ursrtion from Hatche 50 95 Total \"re-reduction cost weeks 1-23 1-34 25 Fixed overhead cost (facilities, debt servrce, etc ] Variable .roduction costs feed, trans-ortation, labor, etc. $015