Three years ago, Linda Williams and her brother-in-law Robert Jones opened Marin Department Store. For the first 2 years, business was good, but the following condensed income statement results for 2022 were disappointing. MARIN DEPARTMENT STORE Income Statement For the Year Ended December 31, 2022 Net sales       $730,000   Cost of goods sold       584,000   Gross profit       146,000   Operating expenses                 Selling expenses   $103,750             Administrative expenses   20,750               124,500   Net income       $21,500   Linda believes the problem lies in the relatively low gross profit rate of 20%. Robert believes the problem is that operating expenses are too high. Linda thinks the gross profit rate can be improved by making two changes. (1) Increase average selling prices by 15%; this increase is expected to lower sales volume so that total sales dollars will increase only 4%. (2) Buy merchandise in larger quantities and take all purchase discounts. These changes to purchasing practices are expected to increase the gross profit rate from its current rate of 20% to a new rate of 25%. Linda does not anticipate that these changes will have any effect on operating expenses. Robert thinks expenses can be cut by making these two changes. (1) Cut 2023 sales salaries of $62,250 in half and give sales personnel a commission of 2% of net sales. (2) Reduce store deliveries to one day per week rather than twice a week; this change will reduce 2023 delivery expenses of $41,500 by 40%. Robert feels that these changes will not have any effect on net sales. Linda and Robert come to you for help in deciding the best way to improve net income. Prepare a condensed income statement for 2023 assuming Linda’s changes are implemented. Prepare a condensed income statement for 2023 assuming Robert’s ideas are adopted. Prepare a condensed income statement for 2023 assuming both sets of proposed changes are made. (Round answers to 0 decimal places, e.g. 5,275.)

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter7: Inventory Cost Flow Assumptions (fifolifo)
Section: Chapter Questions
Problem 7R: Del Rio began Rio Enterprises on January 1 with 200 units of inventory. During the year, 500...
icon
Related questions
Topic Video
Question

Three years ago, Linda Williams and her brother-in-law Robert Jones opened Marin Department Store. For the first 2 years, business was good, but the following condensed income statement results for 2022 were disappointing.

MARIN DEPARTMENT STORE
Income Statement
For the Year Ended December 31, 2022
Net sales
     
$730,000
 
Cost of goods sold
     
584,000
 
Gross profit
     
146,000
 
Operating expenses
         
      Selling expenses
 
$103,750
     
      Administrative expenses
 
20,750
     
       
124,500
 
Net income
     
$21,500
 


Linda believes the problem lies in the relatively low gross profit rate of 20%. Robert believes the problem is that operating expenses are too high. Linda thinks the gross profit rate can be improved by making two changes. (1) Increase average selling prices by 15%; this increase is expected to lower sales volume so that total sales dollars will increase only 4%. (2) Buy merchandise in larger quantities and take all purchase discounts. These changes to purchasing practices are expected to increase the gross profit rate from its current rate of 20% to a new rate of 25%. Linda does not anticipate that these changes will have any effect on operating expenses.

Robert thinks expenses can be cut by making these two changes. (1) Cut 2023 sales salaries of $62,250 in half and give sales personnel a commission of 2% of net sales. (2) Reduce store deliveries to one day per week rather than twice a week; this change will reduce 2023 delivery expenses of $41,500 by 40%. Robert feels that these changes will not have any effect on net sales.

Linda and Robert come to you for help in deciding the best way to improve net income.

Prepare a condensed income statement for 2023 assuming Linda’s changes are implemented.

Prepare a condensed income statement for 2023 assuming Robert’s ideas are adopted.

Prepare a condensed income statement for 2023 assuming both sets of proposed changes are made. (Round answers to 0 decimal places, e.g. 5,275.)

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 6 images

Blurred answer
Knowledge Booster
Accounting for Merchandise Inventory
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781305084087
Author:
Cathy J. Scott
Publisher:
Cengage Learning
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Financial Reporting, Financial Statement Analysis…
Financial Reporting, Financial Statement Analysis…
Finance
ISBN:
9781285190907
Author:
James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning