Three Accounting Questions in Excel

/in /by

This assignment is Required to be completed using Excel all calculations must be reflected in your spreadsheet.

1)

a. What is the breakeven in units?

b. The margin of safety in unit for:

i. 2016

ii. 2017

iii. 2018

2) A new piece of manufacturing equipment is being considered for purchase. this machine is projected to reduce total cost of goods sold 18% (based on 2018 actual results) and have a useful life of 5 years. If the machine cost $2,500,00 should it be purchased? Explain

3) The company has calculated that 40% of the variable cost of goods sold are attributable to direct materials, and 60% of the variable cost of goods sold are associated with direct labor. What is the direct materials cost per item 2018?

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.