Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 1 Al-Rashid Custom Lights LLC, of Ras Al Khaimah, manufactures qual electric light bulbs for distribution world-wide. Relevant costs are as follows - Sa

image text in transcribed
Question 1 Al-Rashid Custom Lights LLC, of Ras Al Khaimah, manufactures qual electric light bulbs for distribution world-wide. Relevant costs are as follows - Sa . Silica for glass fabrication-AED 2.50 per bulb x235 . Lime and Sodium Carbonate AED 0.20 per bulb .Copper, for contacts AED 1.50 per bulb Tungsten for filaments AED 1.00 per bulb Utilities (electricity water, telephone etc)-AED 7.900 per month . Pactory rent and business insurance AED 6,500 per month Wages for casual plant operators-AED 17 50 per bulb .' Salaries for permanent staff- AED 145,800 per month The number of light bulbs manufactured in January 2012 was quantities increased by 10% of this value each month, for the months February to December 2012 and production Each light bulb was sold at AED 27.50 to dealers, and you may assume that all items manufactured were sold (that is, closing inventories were zero each month) Sketch a worksheet layout that- a) Displays Fixed, Variable and Total costs for each month (20 marks) b) Displays the sales volume for each month required to break even (20 marks) Your worksheet sketch should indicate what types of content the cells will hold (data, functions or formulae) and what types of cell references (absolute or relative). An additional 10 marks will be given for clearly laid out worksheets

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_2

Step: 3

blur-text-image_3

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

Selected Materials From Managerial Accounting

Authors: Ray H. Garrison

12th Edition

0077331559, 978-0077331559

More Books

Students also viewed these Accounting questions