Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part 2 (10 marks) The Oily Bike Company (OBC) makes high end racing bikes. This year it will produce 12,000 at a cost of 2,500

Part 2 (10 marks)

The Oily Bike Company (OBC) makes high end racing bikes. This year it will produce 12,000 at a cost of 2,500 each.

The production variable costs are, per bike:

  • Materials - 325
  • Labour - 475
  • Other - 130

The fixed costs this year are:

  • Property related - 825,000
  • Salaries - 1,290,000
  • Other - 3,750,000

The company has borrowings of 7.5 million, at an annual interest rate of 5%. It pays tax at 19%.

For the forthcoming year it is predicting the following:

  • An increase in sales volume of 7.5% and sales prices of 3%. Variable costs will rise:
    • Materials - 8.25%
    • Labour - 2%
    • Other - 1%
  • Fixed costs are expected to rise:
    • Property related - 3.25%
    • Salaries - 2%
    • Other - 1.75%

The company will borrow a further 1 million, at the same interest rate. The tax rate will remain at 19% for the forthcoming year.

This year the receivables day figure was 50 days. Next year the forecast is 40 days.

  • a.Produce an Excel based model which shows the current income statement and the forecast position. The model should be capable of being used to sensitise the forecast. Your model should show contribution, operating profit, profit before tax and net profit. [This part of the TMA should be answered in an Excel file, referenced from your Word document] (8 marks)

  • b.Estimate the cash received from customers, showing workings. [This part of the TMA should be answered in an Excel file, referenced from your Word document] (2marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investment Analysis And Portfolio Management

Authors: Frank K. Reilly, Keith C. Brown

7th Edition

0324171730, 978-0324171730

More Books

Students also viewed these Finance questions

Question

3. Discuss some o f the difficul t i es nnd sugge

Answered: 1 week ago