Data Analyses of Single Cost Driver - Accounting & Finance Assignment Help

Assignment Task

Task

Questions: these can be answered using the excel data. Please run a regression (data analysis) to help. 

1. How much is the total targeted sale in units for the year if the company wants to make a total contribution margin (CM)  of $6,000,000 using the volume of productions as the single (regression) cost driver (and using sale price)?
2. How much is the total variable costs for the year, using volume (doses) of productions as the single cost driver?
3. How much is the total cost for the year, using volume (doses) of productions as the single cost driver (based on the current demand)?
4. How much is the total fixed cost for the year using all five drivers listed in the table?
5. How much is the R square for the month using all five drivers listed in the table (show your answer with three decimal places)?
6. How much is the total production cost if the company wants to increase its yearly volume by 50% using the volume of productions as the single (regression) cost driver for the cost function?
7. How much is the breakeven point in value for the year using a single regression model and assuming that the ‘volume of productions (does) is the only relevant cost driver?
8. How much is the total production cost for the year if you want to produce the current volume and use your best single cost function (based on regression) analyses?
9. How much is the weekly breakeven point in value using the High and Low method and assuming that the ‘volume of productions (does) is the only relevant cost driver?
10. How much is the weekly fixed cost  using the High and Low method and assuming that the ‘volume of productions (does) is the only relevant cost driver?
11. How much is the weekly breakeven point in units using the High and Low method and assuming that the ‘volume of productions (does) is the only relevant cost driver?
12. How much is the weekly margin of safety in value for the week with the highest volume using the High and Low method and assuming that the ‘volume of productions (does) is the only relevant cost driver?
13. How much is the weekly margin of safety ratio for the week with the highest volume using the High and Low method and assume that the ‘volume of productions (does) is the only relevant cost driver (with two decimal places)?
14. How much is the weekly margin of safety in value for the week with the lowest volume using the High and Low method and assuming that the ‘volume of productions (does) is the only relevant cost driver?

This Accounting & Finance Assignment has been solved by our Accounting & Finance Expert at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing Style. Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. 

You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turn tin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.