Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. C6 A fix Sales Performance Evaluationn 2Prepare a segment margin
Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. C6 A fix Sales Performance Evaluationn 2Prepare a segment margin pertormance report Drizzdl Industries has gathered the follawing information about the actunl sales and expenses far its pharmaceuticals seumen the s recent year Sales Variable Costo Variable Operating Expenses Direct Fixed Manufac turing Overhead Direct Fixed Operaling Expenses Comman Fixed E S 866.320 143,325 S 162,162 $ 96,300 s 17,280 Budgeted data for d same tine period for the pharmaccucal sgmen are as follows 3 all data are in millionsi Badgeted sales in units Bulge led average sellg price per unil Variable Cost of Goeds Sold per unit 85 Variable Operaing Expenses per un Direct Fixed Manutacturing Overhead (in tocal Direct Fixed Operating Expenses (in cota Comman Fixed Fxpenses Allocated to the Pharaceulical Se vien 90,000 S 16,000 14,000 3 se the blue sliaded areas on the ENTERANSWERStab tee inputs 4 Always use cell references and for mulas where appropriate to receve full credit. Requirements Prepare a segirent margin perormance report for the pharmaceutical seyment. In this report, be sure to nul lnes er lhe contribulien margin, lhe segmenl rgin, and pn inoe. Cak ule a variance and a varianee pereentage for each line in he repert. Check your spelling carefully and do not abbreviate. Follow the format shown in Exhibit 104 Usc te ARS .-dien when calulating variances, and usethe dol-awr sdeetiens tr For U hen describing lhearisra 2 Saving& Suhmitting Solution 1 Save lile to desklop Create tolder on desktop. and label COMPLETED EXCL PROJECIS Save your scluticn in the folder you just created: add-soluticn-date to end ot file name 2Upload and submit your file tobe graded. Navigate hack to the activity window- screen where you downloaded the initial spreadsheet Click Choose buttion under step 3 Click Upload bullon under slep 3 Click Subenit button urder step 4 kate the file you just sived and click Open 12 Vlewing esults I Click on Results tab in MyAccountingLab Click on the Assignment you were working on Click san Puject link; tis will hring up your Scure Card Wilhin Seare Card window, elk on Live Comns Report luwer riyh) le dawnlead spreadsheel wilh leedback Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. C6 A fix Sales Performance Evaluationn 2Prepare a segment margin pertormance report Drizzdl Industries has gathered the follawing information about the actunl sales and expenses far its pharmaceuticals seumen the s recent year Sales Variable Costo Variable Operating Expenses Direct Fixed Manufac turing Overhead Direct Fixed Operaling Expenses Comman Fixed E S 866.320 143,325 S 162,162 $ 96,300 s 17,280 Budgeted data for d same tine period for the pharmaccucal sgmen are as follows 3 all data are in millionsi Badgeted sales in units Bulge led average sellg price per unil Variable Cost of Goeds Sold per unit 85 Variable Operaing Expenses per un Direct Fixed Manutacturing Overhead (in tocal Direct Fixed Operating Expenses (in cota Comman Fixed Fxpenses Allocated to the Pharaceulical Se vien 90,000 S 16,000 14,000 3 se the blue sliaded areas on the ENTERANSWERStab tee inputs 4 Always use cell references and for mulas where appropriate to receve full credit. Requirements Prepare a segirent margin perormance report for the pharmaceutical seyment. In this report, be sure to nul lnes er lhe contribulien margin, lhe segmenl rgin, and pn inoe. Cak ule a variance and a varianee pereentage for each line in he repert. Check your spelling carefully and do not abbreviate. Follow the format shown in Exhibit 104 Usc te ARS .-dien when calulating variances, and usethe dol-awr sdeetiens tr For U hen describing lhearisra 2 Saving& Suhmitting Solution 1 Save lile to desklop Create tolder on desktop. and label COMPLETED EXCL PROJECIS Save your scluticn in the folder you just created: add-soluticn-date to end ot file name 2Upload and submit your file tobe graded. Navigate hack to the activity window- screen where you downloaded the initial spreadsheet Click Choose buttion under step 3 Click Upload bullon under slep 3 Click Subenit button urder step 4 kate the file you just sived and click Open 12 Vlewing esults I Click on Results tab in MyAccountingLab Click on the Assignment you were working on Click san Puject link; tis will hring up your Scure Card Wilhin Seare Card window, elk on Live Comns Report luwer riyh) le dawnlead spreadsheel wilh leedback
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started