I am very confused on the 5 questions in this problem.
So far I have part of question 2 done:
sales 7,636,000
- variable costs 4,866,018
=contribution margin 2,769,982
Any help would be greatly appreciated! thank you!
Help 80s, Mon 6:20 PM Q. Ed Tools Window Excel View Format Data nsert Ch7%20HW-Excel%20 Problem.xlsx sheet c Reader o 006% Layout Tables Charts SmartArt Formulas Data Review Edit Alig Format CelB Gene Wrap Text ondition Paste Delete Form Poffenberg Data Set For the Year Ended December 31, 2016 Uni DM and her Selling & Research& Development Net overhead Exp. Administrative Expense Month Expense 5.400 464,400 08,000 58,050 26,810 2.910 32,000 8.200 8,430 06.000 ebrua 5.300 455.800 56,975 24.200 2.220 32,410 8,200 5.795 4,000 March 5700 90,200 275 30,000 3.0 32,580 8,200 April 8,800 584,800 38,000 49.700 4,970 33,805 8.200 89 025 May 7.200 619,200 44,000 A400 57,300 8.200 82,280 12 June 8.600 739.600 72,000 92,450 81.200 9 880 35,650 8,200 230.220 July 8 B00 758,800 76,000 94,600 85.000 20,200 34,980 8,200 237 820 August 8,300 713,800 88,000 89,225 8.060 8.200 35,000 8.200 15 Septembe 7.250 623,500 45,000 58,270 6,010 33,B00 8.200 83.283 16 34,000 October 6.700 576.200 72,025 48.000 6.120 34,000 8,200 63855 8,000 November 5.900 507,400 63,425 33,990 2.9 32,650 8,200 38.195 18 5.000 30,000 8,700 31,350 8.200 22 2016 Unit Price 23 udgeted 2017 Uni rojected 2017 Unit Vol 92,000 26 2017 Target Profit 2,500,000 Fixed costs in 2017 will be same as those in 2016 Variable costunit will also behave mely in 2017. 30 Quest Sales Reven the cost driver. Using regre ion method tter Graph ethod to ysize th hip OH cost and Sal Othe ling& Administrative co and Sales revenue: Research & Development cost and sales revenue. Write out cost functions for DM&DL Commissions, OH Exp. Other Selling&Admin. Expe 31 R&D Exp, and Interst Exp 32 2. Work out CVP format 201 statement b budgeted 33 34 4. lftarget profit in 2017 is $2,500,00 gnore tax effect, how many units of goods nberg need to sell in 2017? 35 5. If target profit after tax in 2017 is S2,5 0,000 Tax Rate is 35%, how many units of goods Poffenberger need to sell in 2017? 37 Note There here, you need to to find whether they ble costs bored costs to put th in the corect CVP 38 Inputs Sum a Normal Vi ct destin d pre TER
