Rubic_Print_Format Course Code Class Code Assignment Title Total...

Question

Rubic_Print_Format
    Course Code    Class Code    Assignment Title    Total Points
    BUS-600    BUS-600-O500    Topic 6 Problems and Cases    20.0
    Criteria    Percentage    Unsatisfactory (0.00%)    Less Than Satisfactory (74.00%)    Satisfactory (79.00%)    Good (87.00%)    Excellent XXXXXXXXXX%)    Comments    Points Earned
    Topic 6 Ru
ic: Topic 6 Problems and Cases    100.0%
    Completion    10.0%    No problems are attempted.    One of the problems is attempted.    Two of the problems are attempted.    Three of the problems are attempted.    All of the problems are attempted.
    Content    60.0%    The problems demonstrate no understanding of the content.    The problems demonstrate little understanding of the content.    The problems demonstrate a general understanding of the content.    The problems demonstrate a strong understanding of the content.    The problems demonstrate mastery of the content.
    Technical Requirements    30.0%    The assignment is submitted with another tool (Word, PowerPoint, etc.), but is not submitted via an Excel file with one problem or case per worksheet, as required.    The assignment is submitted via an Excel file with one problem or case per worksheet, as required, but there is no demonstration of the appropriate use of the Excel formulas.    The assignment is submitted via an Excel file with one problem or case per worksheet, as required. There seems to be limited knowledge about the proper functions of the Excel formulas.    The assignment is submitted via an Excel file with one problem or case per worksheet, as required. There seems to be a general understanding of the proper functions of Excel formulas.    The assignment is submitted via an Excel file with one problem or case per worksheet, as required. There is an excellent use of Excel formulas to demonstrate mastery of the content.
    Total Weightage    100%

rubricprintformat-1wt3ired.xlsx chapter24-n0znvjvs.pdf

Harshit · Accepted Answer

1
	(A)
	University motor pool Budget report for April
	Particulars	Monthly Budget 	April Actual	Over/Under
	Gasoline	1500	1720	220
	Oil, minor, Parts	469	550	81
	Outside repairs	400	495	95
	Insurance	1600	1600	0
	Salaries	7500	7500	0
	Depreciation	5867	5867	0
	Total	17336	17732	396
	No. of Automobiles	16	16	 
	Actual Miles	31250	35000	 
	Cost Per mile	0.555	0.507	 
	Working:-
	Gasoline: (31250 miles/25 mil/ gal) * 1.20 per gallon =$1,500				1500
	Oil, etc = 31250 miles * 0.015 per mile = $469				469
	Outside repairs : 300 per auto * 16 autos /12 months = $400				400
	Insurance = Annual Cost for one auto = 18000/15 autos = $1200 per auto				1200
	Annual Cost for 16 autos = 16*1,200 = $19,200				19200
	Monthly cost = 19200/12 = $1,600				1600
	Salaries and Benefits = No change from present budget ($90,000/12=$1,600)				7500
	Depreciation = Annual depreciation per auto = $66,000/ 15 autos = $4,400 per auto				4400
	Annual depreciation for 16 autos = 4,400/auto *16 = $70,400				70400
	Monthly depreciation = $70,400/12= $5,867				5867
	(B)
	Outside automobile repairs are a function of the use of the automobile over the lifetime. These repair occur irregularly over the year and the life of the car. Therefore the use of 1/12 of the estimated annual outside repair costs adjusted for the no. of cars in operation during a month would appear to be more reasonable.

Rubic_Print_Format Course Code Class Code Assignment Title Total Points BUS-600 BUS-600-O500 Topic 6 Problems and Cases 20.0 Criteria Percentage Unsatisfactory (0.00%) Less Than Satisfactory...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment