Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Health And Safety Environment And Quality Audits A Risk-based Approach

Authors: Stephen Asbury

2nd Edition

0415508118, 978-0415508117

More Books

Students also viewed these Accounting questions