Calculate the overall break-even point in sales value

Reference no: EM132172400

Question: Company Information:

Imperial Woodworking Ltd manufacture specialist wood furniture and sell their products all over Saudi Arabia. The company was established three years ago in Jeddah and is performing well to date. Imperial woodworking Ltd have three main product lines; TV tables, dining table and chairs. The following financial information has been provided.

Financial Information:

TV tables

dining Tables

Chairs

Selling Price per unit

SAR 1,000

SAR 5,000

SAR 700

Direct Materials cost per 1 Kg of wood timber

SAR 50

Kg of wood timber required per unit

Direct Labour hour cost

SAR 30

Sales commission per item sold

SAR 10

SAR 15

SAR 5

Variable manufacturing overhead per unit

SAR 20

SAR 24

SAR 18

Number of labour hours per unit

Budgeted sales in units

300

200

450

Additional Information:

a) Other costs:

Production manager annual salary SAR 60,000

Annual marketing costs SAR 10,000- related to TV tables

General Expenses SAR 5,000

Annual Fixed manufacturing overhead (excluding depreciation) SAR10,000 (20% relates to TV tables)

b) Annual equipment depreciation SAR 10,000

c) The company had 8 TV tables and 100 kg of wood timber in stock at the end of September.

d) Company policy is to maintain 20% of the following months sales level as closing inventory for finished goods.

e) Company policy to maintain 25% of next months' production needs as closing inventory for direct materials.

f) Budgeted sales of TV tables for the next six months are as follows:

October

November

December

January

February

g) Cash collections on sales are as follows:

30% in the month of sale

70% in the month following sale

Receivables at the end of September were SAR 22,000

h) Cash payments on purchases are as follows:

60% in the month of purchase

40% in the following month

Payables at the end of September were SAR 6,000

i) The closing cash balance in September 2018 was SAR 40,000 and it is company policy to maintain cash at this level at the end of each month.

j) The company have access to a 4% bank loan of SAR 70,000

k) The company paid a dividend of SAR 40,000 in November

l) Cash of SAR 50,000 was invested in the company by a private investor in December.

Requirements: Your group has been employed as the management accountants for Imperial Woodworking Ltd and have been asked to prepare a report to the board of directors outlining the following:

a) Using the information above, calculate the following: (45%)

i. Which product is performing the best?

ii. Calculate the overall break-even point in sales value for the company

iii. If the selling price of TV tables is increased to SAR 1,200 per unit, what would be the new overall profit?

iv. Refer to original data, what level of sales must the company achieve to make a profit of SAR 1,500,000?

v. The company is considering eliminating sales commission and increasing salaries by SAR40,000. Outline the implications of making this decision on the overall break-even point in sales value and the overall profit or loss for the company. Should the company proceed with this decision?

b) Using the information above, prepare the master budget for TV tables only for the quarter ending 31th December 2018. (55%)

vi. You are required to prepare the master budget for TV tables only, hence any costs that are shared with the other products should be ignored.

Reference no: EM132172400

Questions Cloud

Describe the assumptions used to make these estimates : Babycakes, a specialty bakery, is the company that will be considered for all parts of your budget planning and control report.

Describe what you foresee as major problems : Next, examine whether it is possible to think without using language. If you believe it is possible, describe the primary ways in which a person might enact.

Why you think your appeals are well-balanced : Step 1: Review The Keys to Persuasion. Are the audience appeals in your essay well-balanced? Share why you think your appeals are well-balanced or unbalanced.

Explain the role and importance of an sm within a company : A Sustainability Manager provides a specific focus on the environmental and social concerns of the company.

Calculate the overall break-even point in sales value : Your group has been employed as the management accountants for Imperial Woodworking Ltd and have been asked to prepare a report to the board of directors.

Examine reasons for measuring sustainability performance : In strategic sustainability planning, it is important to address issues of goal clarity and reasons for failure to deliver performance.

Issues and problems in each case study organisation : Identifies the HRM problems that are present in these organisations - analyses the effects of these problems on the employees, managers and organisational

Technological advance legal requirement social need : Marketing Demand Business Need Customer Request Technological Advance Legal Requirement Social Need.

Explain the rules of forming an s-corp : You are the lead S-Corporations tax specialist in your area. You have been asked to give a talk to business owners interested in this form of organization.

User Account

All Pages