Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This project relates to course learning outcomes 4, 5, and 10 and module learning objectives 1, 2, 3, and 4. Complete the Project on the
This project relates to course learning outcomes 4, 5, and 10 and module learning objectives 1, 2, 3, and 4. Complete the Project on the Excel spreadsheet that contains the data set and submit as an attachment. Total points possible = 50 points. Due June 16, 2019 at 11:59 PM.
G3 A C D F G H K L M Number Operating High/Low Method Variable cost/unit of activity= Fixed cost Trips Costs Cost 2 January 3 February 4 March 5 April 6 May 7 June 8 July 9 August 10 September 11 October 12 November 13 December 705 29965 710 27910 950 33503 Two options d ounch umbers and input 1) Hand crun resulting values; OR 670 26312 Insert text box BELOW showing resulting H/L equation and fill in the box with highlighting color like this one. Be sure to tell what the x and 504 25160 880 29605 y variables represent (e.g., x ?; y= ?) 685 21496 2) Use Excel formulas and cell references to arrive at costs WITHOUT using any actual numbers 610 27320 744 28247 1020 37511 1074 For anyone unfamiliar with Excel, a basic 30974 arithmatic formula begins with "=" and contains cell references (e.g., B4, C9) rather than numbers. 34987 1050 14 15 To multiply, use 16 Cost Prediction To divide, use "/" .. 17 Number of trips Predicted cost To add subtract FIRST before 18 1,000 multiplying or dividing, you must put 19 parentheses around the cell references you wish to add or subtract. 20 21 22 23 24 25 26Step 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