Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

plz answer all parts of question , its urgent,do excel work show its working plz,so i can also able to solve it on excel by

image text in transcribedplz answer all parts of question , its urgent,do excel work show its working plz,so i can also able to solve it on excel by following same .thanks

Question 3 - Total Marks 30 EXCEL Ltd manufactures 3 types of cabinet, the standard, the modern and the premium. The budgeted standard costs for each product are as follows: Standard Modern Premium Direct Material Sq Mtr 3.00 3.50 5.00 Direct Materials 30.00 35.00 50.00 Direct Labour 12.00 15.00 12.00 Variable Overhead 10.00 9.00 13.00 Fixed Overhead 12.00 15.00 14.00 64.00 74.00 89.00 105.00 Sales Price 122.00 118.00 Quarterly Budgeted Volume 1,575 2,310 500 Sales Mix % 36% 53% 11% The following information has also been provided: Direct materials are a specialist rose wood which is priced at 10 per Sq Mt No stocks are being maintained and production volumes are the same as sales volumes Fixed overhead costs are absorbed on the basis of production units Due to recent forest fires in the area where the wood supplier is based the supply of rose wood will be limited to 13,000 Sq Mtr in the coming quarter. (a) Calculate the total breakeven point in units for the quarter. (6 Marks) (b) Advise Excel on the optimum production plan detailing the mix of products they should produce during the next quarter to maximise their profits, calculations must be included in your advice note setting out optimum profit. (12 Marks) (c) List Four are the assumptions of Cost Volume Profit Analysis? (4 Marks) (d) List Four limitations of Cost Volume Profit Analysis? (4 Marks) (e) The purchasing manager has advised that a management accountant would be of great benefit to the business, the managing director has asked you to provide details on the role of the

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

Survey Of Accounting

Authors: Carl S. Warren

1st Edition

0538870850, 9780538870856

More Books

Students also viewed these Accounting questions