Question: 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

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 26

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!