Prepare a budgeted average monthly income statement

Assignment Help Accounting Basics
Reference no: EM131458003

Part a

Question - Yummy Burgers R Us operates a store in Melbourne City, and the following is its averagemonthly income statement:

Revenue

$

$

Food

50,000


Beverages

15,000

65,000

Cost of sales



Food (50% of revenue)

25,000


Beverages (20% of revenue)

3,000

28,000

Gross profit


37,000

Operating expenses



Wages

15,000


Operating supplies

5,000


Administration

3,000


Advertising

2,500


Repairs and maintenance of equipment

1,500


Utilities

2,500


Depreciation

1,000


Interest

1,000

31,500

Profit before tax


$5,500

The owner is currently preparing the budget for next year and is considering the followingalternatives:

1. Reducing the cost of sales for food from 50 per cent to 45 per cent. This would be achieved byreducing portions and improved purchasing. There would be no other changes.

2. Cutting the food cost from 50 per cent to 45 per cent and spending an additional $1500 onadvertising. The advertising should attract new customers and increase the volume of bothfood and beverage revenue by 20 per cent on present levels. The new customers would alsocause monthly other operating expenses to increase as follows:

Wages

$2000

 

Repairs

150

Supplies

400

 

Utilities

400

Administration

200

 

 

 

Required (group)
Prepare a budgeted average monthly income statement for both alternatives.

Required (your individual response)
Advise the ownerwhich alternative you consider best, with reasons.

Part b.

Question - Nardeb Company is a software producer and sales company. Currently, it pays all sales staffon a fixed base salary. Recently, management has been considering switching sales staff across toan incentive-based reward system. Nardeb's chief accountant Polly Xu has prepared somesummarised numbers (see below) for senior management to consider.

Michael Day comments that he cannot see the difference, as the sales level and profit areunchanged. Xu argues that it is the difference in cost structure that matters. She argues that theentity is better off staying with the current structure, because the increase in profit is greaterwhen sales levels increase than it would be with the incentive rewards.


With fixed rewards

With incentive rewards

Sales

$2,500,000

$2,500,000

Variable costs

1,500,000

2,000,000

Contribution margin

1,000,000

500,000

Fixed costs

750,000

250,000

Profit

$250,000

$250,000

Required (group)

a. Explain the basis of Polly Xu's argument.

b. Calculate the Contribution Margin Ratio under each alternative.

c. If sales were to increase by 10 per cent, which alternative would produce the highest increasein profit?

d. Prepare an income statement for each alternative (under the assumption of the increased sales in c. above).

Required (your individual response)

a. Briefly evaluate the contributions of Polly and Michael in the above situation, and then make your recommendations on the incentive rewards proposal. Are there any other factors that need to be considered in making such a management decision?

Part c.

Barton Company requested a sizeable loan from First Commonwealth Bank to acquire a large parcel of land for future expansion. Barton reported current assets of $1,900,000 ($430,000 in cash) and current liabilities of $1,075,000.

The bank initially denied the loan request for a number of reasons, including the fact that the current ratio was below 2:1.

When Barton was informed of the loan denial, the financial controller of the company immediately paid $420,000 that was owed to several trade creditors. The controller then asked the bank to reconsider the loan application.

Required (your individual response)

Please answer the following questions about Barton Company.

Based on these abbreviated facts, would you recommend that the bank approve the loan request? Why? Were the controller's actions ethical?

Verified Expert

The solution contains Word file answering all questions mentioned at above order and an Excel file having alternative 1 and alternative 2 computation.

Reference no: EM131458003

Questions Cloud

Examine three barriers to effective environmental analysis : "The Process of an Environmental Analysis"- Examine barriers to effective environmental analysis. Examine service categories commonly provided by nursing homes.
Find the optimal hedge ratio for kellogg : Kellogg will buy 2 million bushels of oats in two months. Kellogg finds that the ratio of the standard deviation of change in spot and futures prices.
Competition strategies in the bookselling industry : Write an essay titled "Competition Strategies in the Bookselling Industry." Using your textbook and the movie excerpt, address the following questions.
What did the organization miss in its macro environment : What did the organization miss in its macro environment? Discuss the strategic implications of this omission.
Prepare a budgeted average monthly income statement : ACC101 Accounting for Decision Making-Prepare a budgeted average monthly income statement for both alternatives and Calculate the Contribution Margin Ratio
Explain why hedging is like buying an insurance policy : Explain why hedging is like buying an insurance policy. To buy an insurance policy, you need to pay a premium; what is the corresponding premium in hedging?
Niche marketing and customer involvement : Discuss the value proposition of your business or proposition.
What is the perfect or imperfect hedge : Suppose that after you graduate, you plan to be a stock analyst for a major financial institution. You know that if the stock market increases in value.
Examine the effects of increasing carbon dioxide : Examine the effects of increasing Carbon dioxide. Use the procedures from the basic greenhouse effect activity as a basis for your experiment.

Reviews

len1458003

4/11/2017 1:51:03 AM

As this is a group project, you may undertake the analysis in groups of up to 3 members. The material for this assessment is to evaluate threeseparate parts/questions. You need to provide an answer to all three parts. In you submission you should include as an appendix the group’s solution to the questions, showing your contributions to the group work. In the main part of the submission you need to provide your own individual write-up, along with your conclusions and recommendations : The first two parts come from questions in the textbook (Birt et al. (2014)) and are: a) Question 9.59 on Yummy Burgers R Us developing next year’s budget, and b) Question 10.58 on Nardeb Company considering an incentive scheme that changes its cost structure. The third part is a bank loan proposal by the Barton Company which comes from another book on financial decision making (all the needed information given in this document): c) Evaluate the Barton Company’s loan application and the actions of the firm’s financial controller. For your convenience, the questions are reproduced on the following pages with some modifications.

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