Please show how you arrived at all answers through Excel. Please assist with formulas where possible.

Marwick's Pianos, Inc., purchases pianos from a large manufacturer and sells them at the retail level. The pianos cost, on the average, $2,450 each from the manufacturer. Marwick's Pianos, Inc. sells the pianos to its customers at an average price of $3,125 each. The selling and administrative costs that the company incurs in a typical month are presented below: Costs Cost Formula Selling Advertising Sales salaries and commissions . . . . . . Delivery of planos to customers.... $950 per month, plus 8% of sales $30 per plano sold $350 per month $800 per month Depreclation of sales facilities Administrative: Clerical...... .. .. .. .. .$1,000 per month, plus $20 per plano sold During August, Marwick's Pianos, Inc., sold and delivered 40 pianos. Required: 1. Prepare an income statement for Marwick's Pianos, Inc., for August. Use the traditional for mat, with costs organized by function. Redo requirement 1 above, this time using the contribution format, with costs organized by behavior. Show costs and revenues on both a total and a per unit basis down through contribu tion margin. Refer to the income statement you prepared in requirement 2 above. Why might it be mislead- ing to show the fixed costs on a per unit basis? 2. 3