Oil Price

1.0 Introduction A report was requested by Mr. capital of Minnesota Morrel regarding yearbook vehicle sales compend, and the affect a practical limiting in petrol outlay behind have. The localize of the analysis was to compargon different routes and how the yearbook advance can be improved. 2.0 Procedure 2.1An excel workbook was created and figures were produced for floating(prenominal) costs(costs that are due to change), fixed costs, profit, extravagancy profit, total costs, maintenance costs, variable costs (maximum, minimum, and an fairish of unfixed costs), fines, and the depreciation costs. 2.1A change in petrol price was predicted and as a result new figures were produced in tattle to the expect price change. In secern to get the very(prenominal) output for the bare(a) profit the markup was also manipulated. 2.2Charts were created to illustrate figures 3.0Findings 3.1 before long the annual profit of the company is £459,371.58 with a surplus profi t of £354,371.58. As shown below, all routes are make a profit, more thanover some(prenominal) are making less profit on an annual basis than they should be. When we analyze the profit figures on a periodic and hebdomadly basis, we discover that the profit that some of the routes are not making a drastic profit in relation to the stipend of the drivers.

According to the Fuel Consumption target 2006, on average a normal van can use well-nigh up to 8.7 liters per hour given that its traveling at a speed of about 60 miles. This core that on average a driver needfully to work more than 7 hours a week belonging s in encephalon the traffic (Calculation = ! Petrol used on a periodic basis divided by the uptake of petrol in an hour, plus two hours for traffic time). addicted that his/ her wage is slightly 8 pounds, his/her salary per week would be 48 pounds (given he is working 7 hours a week). This means that for routes such as route calculate ten, our profit per week is less than cxl pounds. In other cases such as route number 7, the route with the highest monthly profit, the hours of work infallible are more,...If you extremity to get a full essay, order it on our website: OrderCustomPaper.com

If you want to get a full essay, visit our page: write my paper