AutoSave C Attempton Cost Excel Search File Home Insert Draw Calibri Cut In Copy st Format Peter Club 15 Page Layout Formulas Data Review View Help AA ZE Wap Text -AE33 Merge Center General $ - %98- Conditional Formatas Cell Formatting Table Styles In De Format ASS D 4 5. Situation David Mopen Farms uc grows grapes. They can sell off the grapes in bunches after harvest, or they can further process the rapes into jam, juice, or wine. Because of economies of scale, they have found that they would do the entire harvest as one of the four options (bunches, jam juice, or wine they do not have nor are able to invest in the equipment and resources needed 6 toile a combination of goods at this time. The data related to a typical harvest is as follows: 7 10 11 All costs acted with powing the grapes Picking and cleaning the grapes 5 5 485,000 175,000 Sales volume of intermediate products at split off point $ 800,000 14 15 16 17 costs of further processing intermediate products Jam Juice Wine $ $ $ 68,000 100,000 120,000 19 Sales value of and products Juice Wine $ 5 $ 860,000 875,000 900,000 21 22 2 24 25 Instructions Malecommandation to the Controller should David Mogen Farms LLC all the grapes in bunches, process further into jam process further into juice, or process further into wine? Why? Support your answer with a computation or illustration to support that recommandation. Given the information available to you, how much profit for less will the company make it your recommendation is accepted? (15 points total Joint Cost