A buyer determined a 54% overall markup was required for the season. She made purchases from six different resources valued at $750,000 retail. End of season analysis showed the results below:

X fr E39+'[chapter 5.xlsx]Sheet1'!SA$10 A buyer determined a 54% overall markup was required for the season. She made purchases from six different resources valued at $750,000 retail. End of season analysis showed the results below Cost Resource A Initial Retail Initial MU Final Retail Final MU $50,000 $25,000 $50,000 $83,000 $85,000 Resource B $40,000 Resource C $60,000 $135,000 $130,000 $135,000 $130,000 Resource D $55,000 Resource E $75,000 $170,000 $160,000 Resource F $175,000 $90,000 $165,000 $730,000 $750,000 Total $345,000 Complete the spreadsheet above to show a. Initial markup for each resource. b. Final markup for each resource. c. Initial and final markup for the entire purchase