BUS 210 - Professor Early ASSIGNMENT 8 (Markup/Downs. Price, BEA) Using MS Excel complete the problems: 1. Calculate the Final Selling Price (to the nearest cent and Markup percent to the nearest hundredth percent): Original Selling Price - $5,000.00 1". Markdown - 20% 2. Markdown -10% 1". Markup -12% Final Markdown-5% 2. Mr. Sheet, the owner of Bedsheet Inc., knows his customers will pay no more than $120.00 for a comforter. Mr. Sheet wants a 30% markup on his Selling price. What is the most that Mr. Sheet can pay for each comforter? 3. Now assume Mr. Sheet wants a 30% markup on Cost (instead on selling price). What is Mr. Sheet's Cost? 4. DeWitt Co. sells a kitchen set for $475.00. To promote July 4th. DeWitt runs the following Ad: Beginning each hour up to the 4hr., each kitchen set will be marked down 10%. But, at the end of each hour, we will mark up each set by 1%. Assume Mrs. Swenson buys a kitchen set 1 hr. and 50 min. into the sale. (a) What will she pay for the set? (b) What is the mark up percentage? 5. Angie Bake Shop makes big chocolate chip cookies that cost $2.00 each. Angie expects that 10% of the cookies will fall apart and must be discarded. Angie requires a 60% mark up on her cost and only makes 100 cookies. (a) What should Angie charge for each cookie? Assume the following: Pete Co.grows and sells peanuts. The company sellsit nuts for 2.99. Its total fixed coast is $17,280.00 and its variable cost is $1.55/unit. C now on a Table then using BE Forn A. Calculate Break Even using BE Formula 8. Show on a Table the relationship between production, cost and Profit/(loss). If management anticipates a 10% increase in its overhead (Fix Cost), what would the break even point be? U. If management anticipates a 10% increase in its overhead, but a $.05 drop in its variable cost/ unit, what would the break even point be