Reference no: EM131207088
Accounting & Finance Assignment-
Learning outcomes and pass attainment level:
Demonstrate a use of accounting information for decision making purposes.
Teddington Traditional Toys-
Teddington Traditional Toys manufactures and sells traditional toys in both the UK and Europe. At present they manufacture three such toys:
The selling prices for each of the toys are priced competitively.
Selling prices per toy are:
Toy
|
Selling price
|
Pedal car
|
£40.00
|
Teddy bear
|
£10.00
|
Building blocks
|
£16.00
|
The manufacturing cost is based on the materials used, labour costs and expenses incurred to produce the toy.
Teddington Traditional Toys manufactures the three toys in distinct cells of the production facility as this saves on set up costs and idle time.
Manufacturing costs for each of the toys is provided below:
|
Pedal car
|
Teddy bear
|
Building blocks
|
Per toy:
|
|
|
|
Material cost
|
£11.25
|
£4.20
|
£7.72
|
Labour cost
|
£9.75
|
£3.25
|
£3.75
|
Expenses
|
£4.60
|
£0.55
|
£0.82
|
|
|
|
|
Per month
|
|
|
|
Production overheads
|
£4,500
|
£3,600
|
£1,800
|
Other overheads
|
£1,500
|
£1,200
|
£800
|
Budgeted capacity
|
850
|
10,000
|
2,000
|
Production overheads cover the costs of the production supervisors, line managers, warehouse storage, rent, rates, utility bills and insurance, depreciation of the machines. If actual production exceeds 60% of current budgeted capacity the production overheads will increase by 25%.
The other overhead charge is to cover the advertising, selling and distribution costs as well as the administrative support from the finance and purchasing departments. This cost also covers a membership fee to the British Toy and Hobby Association (BTHA) and the product and public liability insurance.
Required-
Presentation:
1. Use an appropriate and clear layout suitable for the end user of the information presented.
Functions and formulae:
2. Using the information provided in the scenario, you are to produce a single Excel spreadsheet making use of the following MS Excel functions:
i. data validation
ii. logical functions and operators, including the IF statement
iii. V and H lookup
iv. What-if / goal seek
The spreadsheet should clearly show the total income and the total separately each item of cost and total profit.
3. At the budgeted capacity level, for each of the toys, calculate the mark-up and margin per toy.
4. Calculate the break-even quantity for each of the toys.
5. Calculate the margin of safety for each of the toys.
Will the new design conduct heat better
: In order to increase the rate of heat transfer through the bottom of the pan, someone proposes a design for the bottom that consists of a 3-mm-thick copper layer sandwiched between two 2- mm-thick aluminum layers. Will the new design conduct heat ..
|
Discuss the site evaluation steps that should be taken
: Discuss the site evaluation steps that should be taken before starting an excavation project. Which step(s) are likely to contribute the most in preventing excavation injuries?
|
Types of healthcare organizations
: Question: 1: Select a HEDIS measure. Identify which types of healthcare organizations must meet this measure, what the ramifications are for NOT achieving this measure, and how this measure impacts quality.
|
How can workers understanding be verified
: 29 CFR 1926 Subpart CC requires that workers understand the crane safety training they are provided. Suggest some ways to ensure understanding is achieved. How can workers' understanding be verified?
|
Calculate the break-even quantity for each of the toys
: ACC4004 Accounting & Finance Assignment. Teddington Traditional Toys manufactures and sells traditional toys in both the UK and Europe. Calculate the break-even quantity for each of the toys. Calculate the margin of safety for each of the toys
|
List the major levels of management
: List the major levels of management (management hierarchy) which enables an organisation to meet is goal?
|
Determine the frequency
: Determine the frequency at which a 10-H inductance has the following inductive reactances: - 50 Ω , 3770 Ω, 15.7 k Ω and 243 Ω.
|
What are at least two sources of error or weakness
: What are at least two sources of error, weakness, or limitations in the lab design? How might I improve the lab design to account for the issues addressed above?
|
Determine the capacitive reactance
: Determine the capacitive reactance (in ohms) of a 5-mF capacitor for dc and for the following frequencies: 60 Hz, 120 Hz, 1800 Hz, and 24,000 Hz.
|