Question
I wantvto know how can I get the answers
Concert Pianos, Inc., purchases pianos from a well-known manufacturer and resells them at its retail store. Needed information for this lab assignment is given below CONCERT PIANOS, INC. $ 5,300 Average sales price of each piano Number o f pianos sold and delivered in March sts Average cost of each piano (cost of goods sold) st Formula 2,800 per piano Sellin Advertising 950 per month Delivery of pianos per piano sold 4,800 per month plus 5% 60 Sales salaries and commissions Utilities Depreciation of sales facilities of sales per month $ 5,000 per month 650 Administrative: Executive salaries Depreciation of office equipment Clerical Insurance $ 13,500 per month 900 per month $ 2,500 per month plus $40 per piano sold 700 per month
ACCT& 203 Lab 2 -Online Class Winter 2019 Instructor: Pat Carter Points Possible: 10 To receive full credit, you must use cell references (linking) when possible and use Excel formulas for all calculated amounts. In this lab you will analyze the costs of a piano retailer. Using the given data, prepare a traditional income statement for March and a contribution format income statement for March. CONCERT PIANOS, INC. Traditional Income Statement For the Month Ended March 31 $ 291,500 154,000 137,500 Sales Cost of goods sold Gross margin Selling and administrative expenses Selling expenses Advertising Delivery of pianos Sales salaries & commissions Utilities Depreciation of sales facilities Total selling expenses Administrative expenses Executive salaries Depreciation of office equipment Clerical Insurance Total administrative expenses Total selling and administrative expenses Net operating income 950 3,300
CONCERT PIANOS, INC. Contribution Format Income Statement For the Month Ended March 31 Total Per Piano Sales Variable expenses Cost of goods sold Delivery of pianos Sales commissions Clerical Total variable expenses Contribution margin Fixed expenses Advertising Sales salaries Utilities Depreciation of sales facilities Executive salaries Depreciation of office equipment Clerical Insurance Total fxed expenses Net operating income
0 0
Add a comment Improve this question Transcribed image text
Answer #1
CONCERT PIANOS INC.
Contribution Format Income Statement
For the month Ended March 31
Particular Total ($) Per piano
Sales 291500 5300
Variable Expenses
Cost of Good sold 154000 2800
Delivery of pianos 3300 60
Sales Commissions 14575 5% of sales
Clerical 2200 40
Total Variable Expenses 174075
Contribution Margin 117425
Fixed Expenses
Advertising 950
Sales Salaries 4800
Utilities 650
Depreciation sales facilities 5000
Executive salary 13500
Depreciation of equipment 900
Clerical 2500
Insurance 700
Total Fixed expenses 29000
Net operating income 88425
CONCERT PIANOS INC.
Contribution Format Income Statement
For the month Ended March 31
Particular Total ($)
Sales 291500
Cost of good sold 154000
Gross Margin 137500
Sales and Adminstrative expenses
Selling Expenses
Advertising 950
Delivery of piano 3300
Sales salary and commissions 19375
Utilities 650
Depreciation of sales facilities 5000
Total selling expenses 29275
Administrative expenses
Executive salary 13500
Depreciation of equipment 900
Clerical 4700
Insurance 700
Total administrative expenses 19800
Total selling and administrative exp 49075
Net operating Income 88425
Add a comment
Know the answer?
Add Answer to:
I wantvto know how can I get the answers Concert Pianos, Inc., purchases pianos from a...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Need help! Marwick's Pianos, Inc., purchases pianos from a large manufacturer for an average cost of...

    Need help! Marwick's Pianos, Inc., purchases pianos from a large manufacturer for an average cost of $1,509 per unit and then sells them to retail customers for an average price of $3,200 each. The company's selling and administrative costs for a typical month are presented below Cost Formula Costs Selling: Advertising Sales salaries and commissions Delivery of pianos to customers Utilities Depreciation of sales facilities Administrative: Executive salaries Insurance Clerical Depreciation of office equipment $946 per month 54,780 per month,...

  • Marwick’s Pianos, Inc., purchases pianos from a large manufacturer for an average cost of $1,486 per...

    Marwick’s Pianos, Inc., purchases pianos from a large manufacturer for an average cost of $1,486 per unit and then sells them to retail customers for an average price of $2,700 each. The company’s selling and administrative costs for a typical month are presented below: Costs Cost Formula Selling: Advertising $ 934 per month Sales salaries and commissions $ 4,774 per month, plus 4% of sales Delivery of pianos to customers $ 61 per piano sold Utilities $ 653 per month...

  • Problem 1-21 Traditional and Contribution Format Income Statements [LO1-6] Marwick’s Pianos, Inc., purchases pianos from a...

    Problem 1-21 Traditional and Contribution Format Income Statements [LO1-6] Marwick’s Pianos, Inc., purchases pianos from a large manufacturer for an average cost of $1,488 per unit and then sells them to retail customers for an average price of $2,700 each. The company’s selling and administrative costs for a typical month are presented below: Costs Cost Formula Selling: Advertising $ 952 per month Sales salaries and commissions $ 4,824 per month, plus 4% of sales Delivery of pianos to customers $...

  • Marwick’s Pianos, Inc., purchases pianos from a large manufacturer for an average cost of $1,493 per...

    Marwick’s Pianos, Inc., purchases pianos from a large manufacturer for an average cost of $1,493 per unit and then sells them to retail customers for an average price of $3,000 each. The company’s selling and administrative costs for a typical month are presented below: Costs Cost Formula Selling: Advertising $ 934 per month Sales salaries and commissions $ 4,791 per month, plus 5% of sales Delivery of pianos to customers $ 57 per piano sold Utilities $ 664 per month...

  • Problem 1-21 Traditional and Contribution Format Income Statements [LO1-6] Marwick’s Pianos, Inc., purchases pianos from a...

    Problem 1-21 Traditional and Contribution Format Income Statements [LO1-6] Marwick’s Pianos, Inc., purchases pianos from a large manufacturer for an average cost of $1,483 per unit and then sells them to retail customers for an average price of $2,300 each. The company’s selling and administrative costs for a typical month are presented below: Costs Cost Formula Selling: Advertising $ 943 per month Sales salaries and commissions $ 4,807 per month, plus 3% of sales Delivery of pianos to customers $...

  • Problem 1-21 (Algo) Traditional and Contribution Format Income Statements [LO1-6] Marwick's Pianos, Inc., purchases planos from...

    Problem 1-21 (Algo) Traditional and Contribution Format Income Statements [LO1-6] Marwick's Pianos, Inc., purchases planos from a large manufacturer for an average cost of $1,510 per unit and then sells them to re customers for an average price of $2,700 each. The company's selling and administrative costs for a typical month are presented below: Cost Formula costs Selling: Advertising Sal ala and commissions Delivery of pianos to customers Utilities Depreciation of sales facilities Administrative: Executive salaries Insurance clerical Depreciation of...

  • Marwick's Pianos, Inc., purchases pianos from a large manufacturer for an average cost of $1,500 per...

    Marwick's Pianos, Inc., purchases pianos from a large manufacturer for an average cost of $1,500 per unit and then sells them to retail customers for an average price of $2,000 each. The company's selling and administrative costs for a typical month are presented below: Cost Formula Costs Selling: Advertising Sales salaries and commissions Delivery of pianos to customers Utilities Depreciation of sales facilities Administrative: Executive salaries Insurance Clerical Depreciation of office equipment $966 per month $4,804 per month, plus 5%...

  • Marwick's Pisnos, Inc., purchases pianos from a large manufacturer for an average cost of $1,520 per...

    Marwick's Pisnos, Inc., purchases pianos from a large manufacturer for an average cost of $1,520 per unit and then sells them to retail customers for an average price of $2.800 esch. The company's selling and administrative costs for a typical month are presented below: Cost Formula Selling: Advertising Sales salaries and commissions Delivery of pianos to customers Utilities Depreciation of sales facilities Administrative: Executive salaries $957 per month $4,773 per month, plus 5% of sales $61 per piano sold $668...

  • Marwick's Pianos, Ic., purchases pianos from a large manufacturer for an average cost of $1,511 per...

    Marwick's Pianos, Ic., purchases pianos from a large manufacturer for an average cost of $1,511 per unit and then sells them to retail customers for an average price of $2,600 each. The company's selling and administrative costs for a typical month are presented below: Cost Formula Costs Selling: Advertising $967 per month $4,823 per month, plus 3% of sales $60 per piano sold $657 per month $5,017 per month Sales salaries and commissions Delivery of pianos to customers Utilities Depreciation...

  • Marwick's Pianos, Inc., purchases pianos from a large manufacturer for an average cost of $1,496 per...

    Marwick's Pianos, Inc., purchases pianos from a large manufacturer for an average cost of $1,496 per unit and then sells them to retail customers for an average price of $3,100 each. The company's selling and administrative costs for a typical month are presented below: Costs Selling: Cost Formula Advertising Sales salaries and commissions Delivery of pianos to customers Utilities Depreciation of sales facilities $944 per month 4,818 per month, plus 4% of sales $62 per piano sold $658 per month...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT