Question

job 1 given information

Martin

days taken 10, Man Hours 200, Material cost $17,950,

Labour Cost $4,200, Overhead cost 1,906.67, total cost 24,056.67 or 24,057, Invoice Amount $25,920

budgeted MOH WHICH it is 71500

budgeted direct labour hr which is 7500

based on job one calculate the following

- calculate the profit margin ($) for job 1

- calculate the Gross Profit Margin for job 1

-Format the Gross Profit Margin figures to show as a percentage

-calculate the total number of days spent on the completed jobs

-calculate the total revenue.

- calculate the Average Material Cost rounded to the nearest 10

-calculate the Highest Labour Cost. "i need the formula I have all the data the same as Martin data" how to do it

-calculate the Lowest Labour cost "i need the formula I have all the data the same as Martin data" how to do it

- calculate the Number of Completed Jobs "i need the formula I have all the data the same as Martin data" how to do it

- calculate the total number of jobs managed by Amir "i need the formula I have all the data the same as Martin data" how to do it

- calculate the average revenue of jobs managed by Amir "i need the formula I have all the data the same as Martin data" how to do it

- calculate the total $ profit for jobs managed by Amir. "i need the formula I have all the data the same as Martin data" how to do it