Prepare a schedule showing the change in revenues

Assignment Help Accounting Basics
Reference no: EM131784228

Problem - Superior Markets, Inc., operates three stores in a large metropolitan area. A segmented income statement for the company for the last quarter is given below:

SUPERIOR MARKETS, INC. Income Statement For the Quarter Ended September 30

 

Total

North Store

South Store

East Store

Sales

$3,000,000

$720,000

$1,200,000

$1,080,000

Cost of goods sold

1,657,200

403,200

660,000

594,000

Gross margin

1,342,800

316,800

540,000

486,000

Selling and administrative expenses:





 Selling expenses:





   Sales salaries

239,000

70,000

89,000

80,000

   Direct advertising

187,000

51,000

72,000

64,000

   General advertising

45,000

10,800

18,000

16,200

   Store rent

300,000

85,000

120,000

95,000

   Depreciation of store fixtures

16,000

4,600

6,000

5,400

   Delivery salaries

21,000

7,000

7,000

7,000

   Depreciation of delivery equipment

9,000

3,000

3,000

3,000

 Total selling expenses

817,000

231,400

315,000

270,600

 Administrative expenses:





   Store management salaries

70,000

21,000

30,000

19,000

   General office salaries

50,000

12,000

20,000

18,000

   Insurance on fixtures and inventory

25,000

7,500

9,000

8,500

   Utilities

106,000

31,000

40,000

35,000

   Employment taxes

57,000

16,500

21,900

18,600

   General office - other

75,000

18,000

30,000

27,000

  Total administrative expenses

383,000

106,000

150,900

126,100

Total expenses

1,200,000

337,400

465,900

396,700

Net operating income (loss)

$142,800

$(20,600)

$74,100

$89,300

Additional Data:

Manager's salary per quarter

$12,000

New employee's salary per quarter

$11,000

Employment tax as a percentage of salaries

15%

Delivery person's salary per quarter

$4,000

Insurance related to downtown fixtures

1/3

Discharged employee's salary per quarter

$6,000

Assumed sales transferred to East store

25%

The North Store has consistently shown losses over the past two years. For this reason, management is giving consideration to closing the store. The company has retained you to make a recommendation as to whether the store should be closed or kept open. The following additional information is available for your use:

a. The breakdown of the selling and administrative expenses is as follows:

b. The lease on the building housing the North Store can be broken with no penalty.

c. The store fixtures being used in the North Store would be retained and transferred to the other stores if the North Store were closed.

d. One of the store managers of the North Store would be retained and transferred to another position in the company if the North Store were closed. She would be filling a position that would otherwise be filled by hiring a new employee. The general manager of the North Store would be retained at her normal salary of $12,000 per quarter. All other employees and managers would be discharged.

e. The company has one delivery crew that serves all three stores. One delivery person could be discharged if the North Store were closed. This person's salary is $4,000 per quarter. The delivery equipment would be distributed to the other stores. The equipment does not wear out through use, but does eventually become obsolete.

f. The company's employment taxes are 15% of salaries.

g. One-third of the insurance in the North Store is on the store's fixtures which will be transferred to the other stores along with the fixtures.

h. The "General office salaries" relate to the overall management of Superior Markets, Inc. If the North Store were closed, one person in the general office could be discharged because of the decrease in overall workload. This person's salary is $6,000 per quarter.

i. General office-other also relates to the overall operation of Superior Markets, Inc., and will be allocated to the other stores if North Store is closed.

Required: Prepare a schedule showing the change in revenues and expenses and the impact on the company's overall net income that would result if the North Store were closed. What is your recommendation?

Reference no: EM131784228

Questions Cloud

Experiment to test hypothesis : Identify the specific independent and dependent variables that will be involved in an experiment to test this hypothesis.
What is the energy and frequency of the photon : What is the energy and frequency of the photon to raise the electron in a hydrpgen atom from the energy level n=2 to n=4?
Can anyone give some examples of users that would interested : Some are more important to some users than others. Can anyone give some examples of users that would be more interested in one than the other?
Determine the equation for the tube in torsional vibration : Determine the equation for the tube of Figure in torsional vibration using (a) two elements and (b) N-stepped uniform elements.
Prepare a schedule showing the change in revenues : Prepare a schedule showing the change in revenues and expenses and the impact on the company's overall net income that would result
One mutual fund that reflects your investment style : One mutual fund that reflects your investment style, You will be developing a simple portfolio that will be used for analysis over the following five weeks
Analyze the significant rules concerning the manner : Analyze the significant rules concerning the manner in which corporations treat the dividends that they are paying.
What will be the amount of accumulated depreciation on asset : Assuming the asset's salvage value is $2,600, what will be the amount of accumulated depreciation on this asset on December 31, Year 4?
Discuss gross receipts and taxable income : Aqua, Inc., a calendar year corporation, has the following gross receipts and taxable income for 2013-2016

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd