Lastname Firstname - Excel (Product Activation failed File Data Review View Tell me what you want to do.. AutoSum-A7 General Normal 2 Normal 3 A Home Insert Page Layout Formulas X Cut Calib - 11 - E Copy TO BIU - A) - A *Formal Painter clipboard - fon Pasle Wrap Text = = = = = = Merge Center Alignment 6 X Sign in . Share 47 o Surl & Find & & & Clear Filter Select Editing - Comma 2 Conditional Formulas Normal Formatting Table .% Bad Goud Insert Delele Formal Number Styles A19 G 1 J K M M B C D C 11 1 Uniform BG Inc. is a company based in Blagoevgrad that makes uniforms. 2 They normally sell 450 uniforms per month. Each uniform uses 3 meters of cloth which costs $2.5 per meter. 3 Each uniform requires one and a half hour of labor, labor costs $4 an hour. 4 Also the company uses a machine in its production, the depreciation at the machine is $200 per month. 5 The rent is $1,000 and the supervisor salary is $1,500 per month. Cach uniform is sold for $30 6 7 Required (15 points each): 8 a) Create the contribution format income Statement based on the 450 uniforms, 9 b) How many uniforms does Uniform BG Inc. need to sell to break even? 10 c) If they would like to have a profit of $8,000, how many uniforms do they need to sell? 11 d) What is the margin of safety as a percentage? What is Margin of safety, what do you understand by it? 12 e) What is the operating leverage ratio of this company? Is that a good ratio? 13 f) They are approached by Plovdiv Machines Itd. to create 225 custom uniforms for their staff, 14 In order to create them, they need to print the name of the company in each unitarm which costs $0.50 per unitorm. Fixed costs do not change! 15 What is the rninurnum total price they would sell them for if they want to make at least $1,200 on this entire order? 16 17 Solve here: 18 19 20 21 22 23 24 25 28 27 28 29 30 Problem 1 Probleri 2 Problem 3 Reavy 100% o x) 1C . EA EL 12:35 11/3/2022 Lastname Firstname - Excel (Product Activation failed File Data Review View Tell me what you want to do.. AutoSum-A7 General Normal 2 Normal 3 A Home Insert Page Layout Formulas X Cut Calib - 11 - E Copy TO BIU - A) - A *Formal Painter clipboard - fon Pasle Wrap Text = = = = = = Merge Center Alignment 6 X Sign in . Share 47 o Surl & Find & & & Clear Filter Select Editing - Comma 2 Conditional Formulas Normal Formatting Table .% Bad Goud Insert Delele Formal Number Styles A19 G 1 J K M M B C D C 11 1 Uniform BG Inc. is a company based in Blagoevgrad that makes uniforms. 2 They normally sell 450 uniforms per month. Each uniform uses 3 meters of cloth which costs $2.5 per meter. 3 Each uniform requires one and a half hour of labor, labor costs $4 an hour. 4 Also the company uses a machine in its production, the depreciation at the machine is $200 per month. 5 The rent is $1,000 and the supervisor salary is $1,500 per month. Cach uniform is sold for $30 6 7 Required (15 points each): 8 a) Create the contribution format income Statement based on the 450 uniforms, 9 b) How many uniforms does Uniform BG Inc. need to sell to break even? 10 c) If they would like to have a profit of $8,000, how many uniforms do they need to sell? 11 d) What is the margin of safety as a percentage? What is Margin of safety, what do you understand by it? 12 e) What is the operating leverage ratio of this company? Is that a good ratio? 13 f) They are approached by Plovdiv Machines Itd. to create 225 custom uniforms for their staff, 14 In order to create them, they need to print the name of the company in each unitarm which costs $0.50 per unitorm. Fixed costs do not change! 15 What is the rninurnum total price they would sell them for if they want to make at least $1,200 on this entire order? 16 17 Solve here: 18 19 20 21 22 23 24 25 28 27 28 29 30 Problem 1 Probleri 2 Problem 3 Reavy 100% o x) 1C . EA EL 12:35 11/3/2022
