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

  Examine any horizontal changes in starbucks accounts balance

Provide a concise, professional introduction explaining the purpose of your analysis to your executive. Use basic financial analysis to examine any horizontal changes in Starbucks' accounts receivable balances over time.

  The financial statements of hudson manufacturing company

the financial statements of hudson manufacturing company report net sales of 500000 and accounts receivable of 50000

  What is an uncorrected misstatement

What is an uncorrected misstatement? What is the auditors' responsibility for uncorrected misstatements during the completion stage of the audit engagement

  Calculate the effect on the overall companys net operating

tracey douglas is the owner and managing director of heritage garden furniture ltd. a south african company that makes

  Determine the balances of the accounts affected by the

Cambridge Company is a small editorial services company owned and operated by Dave Maier. On December 31, 2008, the end of the current year, Cambridge Company's accounting clerk prepared the unadjusted trial balance shown at the top of the following ..

  Dennis is currently considering investing in municpal bonds

dennis is currently considering investing in municpal bonds that earn 8.80 percent interest or in a taxable bonds

  Calculate the cost per unit of cost driver for each cost

Pumpkin Bags (PB) is a desiger of high quality backpacks and purses. Each design is made in small batches. Each spring, PB comes out with new designs for the backpack and for the purse.

  Difference between implied consent and informed consent

Describe the difference between implied consent and informed consent and give an example of each

  Make sure that you consider each transaction separately and

quail corporation was created in 2000 through contributions from kasha 700000 and fardin 300000. in a transaction

  Assume that simple co had credit sales of 259000 and cost

assume that simple co. had credit sales of 259000 and cost of goods sold of 159000 for the period. simple uses the

  How much of each payment is deductible by rebecca

Under a court-ordered decree of separate maintenance executed in 2014, Rebecca is required to pay her ex-husband, Carl, $4,750 a month until their youngest son.

  Market place selling electrical appliances

Mr. Raghunath was happy that Rahul showed keen interest in his business but was worried about Ram who would always spend time with computers.

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