Create in Microsoft Excel, a template that does the following:
Column A – Your Company’s Quantity Produced/Total Cost
Column B – A Competitor/Complement Company’s Sales/Total Revenue
Column C – Your Company’s Overhead Cost
Use your yellow sticky number to find the “block” of random numbers, on your random number table. That first block of random numbers will be your Column A, the block right below that, will be your Column B, the block right below that will be your Column C.
In Excel, under Formulas, More Functions, Statistical, Correl – do a correlation coefficient for Your Company’s Q/TC and Competitor/Complement Company’s Sales/TR. Then do another correlation coefficient for Your Company’s Q/TC and Your Company’s Overhead Cost.
State which variable is the most correlated to Your Company’s Q/TC.
Set up Excel formula that states the average for each coiumn, in the cell right below the last value of each column.
Then create, in Excel, a brief Income Statement:
Your Budgeted Revenue set up Excel formula so this is 1.5 times “Your Total Cost”
(Your Total Cost) set up Excel formula so this is 85 times the average of the most correlated variable
Your Net income
Create in Microsoft Excel, a template that does the following: Column A – Your C
Important - Read this before proceeding
These instructions reflect a task our writers previously completed for another student. Should you require assistance with the same assignment, please submit your homework details to our writers’ platform. This will ensure you receive an original paper, you can submit as your own. For further guidance, visit our ‘How It Works’ page.
