Question

In: Accounting

Question 1 Required: Forecasting is an important business process to enable planning and preparation. Describe THREE...

Question 1

Required:

Forecasting is an important business process to enable planning and preparation.

Describe THREE (3) techniques that could be used to forecast costs. Illustrate your answer with the use of simple numerical examples.

Evaluate the usefulness of these three techniques. (maximum word count 500 words)

Question 2

The Feathered Friends Company is a small business manufacturing products for domestic and wild birds. Its best-selling product is the ‘fat ball’ that can be hung or placed in a garden to provide healthy nourishment for wild birds during cold winters.

The standard material cost per ‘fat ball’ is as follows:

£

Fat

50g @ £6.80/kg

0.34

Nuts

30g @ £13.00/kg

0.39

Seeds

100g @ £2.50/kg

0.25

Total standard material cost per ‘fat ball’

0.98

[1 kg = 1,000g]

5,000 ‘fat balls’ were produced and sold in the second quarter of the year (April – June), incurring the following material costs:

£

Fat

150kg

1,083

Nuts

220kg

2,552

Seeds

650kg

1,300

Total material cost incurred

4,935

The management accountant met with the production manager to review the variances that had been calculated. The production manager observed that some of the original information on the standard cost card was out of date. He specifically noted the following points:

  • A new type of fat had been introduced which required significantly less of the input, now only 25g per ball, but had a higher cost of £7.60/kg.
  • In response to published research into birds’ diets the quantity of nuts in a ‘ball’ was increased by 20g. The supplier of nuts had increased the price to £14.40/kg.
  • The new fat was able to bind together more seeds, so the quantity of seeds input rose by 20% for each ‘fat ball’. The price of seeds had fallen to £2.00/kg.

Required:

  1. Produce a reconciliation of the original standard material cost of actual production of ‘fat balls’ in the second quarter to the actual material cost incurred, showing the total planning variance and all operational material variances.   
                                                                                                                    
  2. Discuss the potential benefits and problems of calculating separate planning and operational variances. (maximum word count 180 words)                   

Question 3

Julie’s Cleaning Services is considering expanding its domestic cleaning operations to include the provision of carpet cleaning. This will require the purchase of 20 specialised carpet cleaning machines, at a cost of £400 each, to be used by the team of cleaners. The company will treat this expenditure as a fixed cost.

This is a large additional cost for the business, but Julie expects that the demand for this service is sufficient to warrant charging a fee of £75 per room carpet. The variable costs incurred per clean are £21 which include all labour and materials costs.

Required:

  1. Calculate the number of carpet cleans that Julie’s Cleaning Services needs to carry out to avoid losing money on the new carpet cleaning activity.

  1. The breakeven calculation carried out in part (a) required a number of assumptions to be made regarding the carpet cleaning business proposal. Discuss THREE (3) of the following assumptions, providing examples of where they may be valid, and where they may not be valid, in the situation facing Julie’s Cleaning Services.
  • Fixed costs remain constant regardless of activity level
  • Variable costs vary proportionately with activity
  • Total costs and total revenue are linear functions of output
  • There is no uncertainty

                                                 (maximum word count 300 words)

Julie is considering refining the pricing model for the carpet cleaning to allow for different sized room carpets (lower prices for smaller rooms). Describe, using a numerical example, how the calculations in part (a) will be amended to allow for this pricing model. (maximum word count 120 words)                         

Question 4

Fancy Flowers Ltd is considering how many bouquets of flowers it will need at its stall at a local arts festival that is running for a few weeks. Due to supplier issues, it must choose in advance whether to prepare 200, 300 or 400 bouquets per day. Demand for bouquets can be 200, 300 or 400 per day at the festival. Any flowers not sold on the day will have to be thrown away.

The price charged per bouquet is £20, and the variable cost is £8 per bouquet. If the demand for bouquets exceeds the number of bouquets taken to the festival, then customers will have to be turned away. Fancy Flowers Ltd estimates that if this situation arises, it would cost the company £200 in loss of goodwill, irrespective of the number of customers turned away (i.e. the loss would be £200 if 100 customers were disappointed or if 300 were disappointed).

Required:

  1. Prepare a pay-off table showing the profits for Fancy Flowers Ltd at all combinations of the number of bouquets prepared and demanded in each day.

  1. Showing clearly your method and calculations, recommend the number of bouquets that should be prepared in advance using the following decision-making criteria:
  1. Maximax
  2. Maximin
  3. Minimax regret
    1. Identify the additional information that would be required to calculate the expected demand for bouquets that Fancy Flowers Ltd may face each day, and describe how this calculation would be done.

    1. Discuss TWO (2) benefits of the use of the expected value technique as a decision-making basis in the situation facing Fancy Flowers Ltd.

                                                           (maximum word count 140 words)

    Solutions

    Expert Solution

    Questions 1:- Techniques to forecast the cost are:

    1) Qualitative method

    2) Time Series Analysis

    3) causal Method

    #Qualitative Forecasting Methods

    The qualitative(or critical) approach can be helpful in defining transient conjectures and can likewise enhance the projections dependent on the utilization of any of the quantitative techniques.

    Four of the better-known subjective guaging strategies are official assessments, the Delphi strategy, deals power surveying, and shopper reviews:

    1. Exicutive Opinions

    The abstract perspectives on administrators or specialists from deals, creation, account, buying, and organization are arrived at the midpoint of to produce a gauge about future deals. Typically this strategy is utilized related to some quantitative technique, for example, pattern extrapolation. The supervisory group alters the subsequent estimate, in light of their desires.

    2. Delphi Method

    This is a gathering procedure where a board of specialists is interrogated exclusively concerning their view of future occasions. The specialists don't meet as a gathering, so as to diminish the likelihood that agreement is reached on account of prevailing character factors. Rather, the figures and going with contentions are summed up by an outside gathering and came back to the specialists alongside further inquiries. This proceeds until an agreement is reached.

    3. Sales Force Polling

    A few organizations use as a gauge source sales reps who have constant contacts with clients. They accept that the salesmen who are nearest to a definitive clients may have noteworthy experiences in regards to the condition of things to come showcase. Conjectures dependent on deals power surveying might be found the middle value of to build up a future gauge. Or then again they might be utilized to alter other quantitative as well as subjective estimates that have been created inside in the organization.

    4. Customer Surveys

    A few organizations lead their own market overviews in regards to explicit customer buys. Overviews may comprise of phone contacts, individual meetings, or surveys as a methods for getting information. Broad measurable investigation as a rule is applied to study brings about request to test speculations with respect to buyer conduct.


    Related Solutions

    describe how the travel demand forecasting is a part of the transportation planning process and its...
    describe how the travel demand forecasting is a part of the transportation planning process and its elements?
    Describe the purposes and methods of forecasting and planning.
    Describe the purposes and methods of forecasting and planning.
    human resource planning and forecasting( human resource planning process, forecasting HR requirements, methods to forecast HR...
    human resource planning and forecasting( human resource planning process, forecasting HR requirements, methods to forecast HR needs)
    Describe the tools and techniques required for planning communications and explain why each is important for...
    Describe the tools and techniques required for planning communications and explain why each is important for effective communication management
    how excess capacity impacts the planning process of financial forecasting.
    how excess capacity impacts the planning process of financial forecasting.
    Describe the budget planning process for your household. Then describe the budget planning process for a...
    Describe the budget planning process for your household. Then describe the budget planning process for a company, as well as the procedures that should be followed at the end of the accounting period to compare budgeted figures to actual costs. How can management address the variances? Give examples.
    Based on Amazon company. answer the following question. Planning,Sales,Forecasting and Budgeting application criteria: 1. strategic planning...
    Based on Amazon company. answer the following question. Planning,Sales,Forecasting and Budgeting application criteria: 1. strategic planning and linkage to strategic marketing 2. efficient and effective sales strategy 3. forecasting approaches and methods of sales forecasting 4. purpose and process of sales budget. distribution management (SCM)
    Identify and describe at least three aspects of proper audit planning and why they are important.
    Identify and describe at least three aspects of proper audit planning and why they are important.
    Why is forecasting important to businesses. What type of business forecasting do you think would best...
    Why is forecasting important to businesses. What type of business forecasting do you think would best suit your line of work? Or describe a forecasting need for a company and discuss how it helps the business. Explain your answer.
    Briefly describe the following steps of the forecasting process. 1. determine the purpose of forecast 2....
    Briefly describe the following steps of the forecasting process. 1. determine the purpose of forecast 2. Establish time horizon 3.Gather &analyze relevant historical data 4. Select a forecasting technique 5. Prepare forecast 6. Monitor the forecast
    ADVERTISEMENT
    ADVERTISEMENT
    ADVERTISEMENT