Creating Financial Reports for MovinOn Inc. In this project, you work with Kristina Romano, an…

Creating Financial Reports for MovinOn Inc.

In this project, you work with Kristina Romano, an
accountant in the Washington warehouse of MovinOn Inc. Kristina needs to
prepare a series of financial reports to present to David Bowers, owner of
MovinOn, the warehouse managers, and the accountants at MovinOn at their annual
meeting. They are naturally interested in how much revenue recent jobs have
generated, as well as the labor costs that offset this revenue.

Complete the following:

The next report that Kristina needs should show the income
from recent moving jobs. MovinOn charges $.70
»

Creating Financial Reports for MovinOn Inc.

In this project, you work with Kristina Romano, an
accountant in the Washington warehouse of MovinOn Inc. Kristina needs to
prepare a series of financial reports to present to David Bowers, owner of
MovinOn, the warehouse managers, and the accountants at MovinOn at their annual
meeting. They are naturally interested in how much revenue recent jobs have
generated, as well as the labor costs that offset this revenue.

Complete the following:

The next report that Kristina needs should show the income
from recent moving jobs. MovinOn charges $.70 per mile plus $.20 per pound for
each job. From this total, Kristina deducts the driver’s payment to determine
the net income for the moving job. Drivers receive $50 for each job plus their
mileage rate (that is, the driver’s rate multiplied by the number of miles plus
$50). Kristina asks you to create an income report that provides the job ID,
the date of the move, the driver’s name and rate, the mileage and weight of the
job, and the income calculations as described. At the end of the report,
Kristina wants to show the total income, the total payments to drivers, and the
total net income. (Hint: Consider creating a query as the basis for this
report.) Name the report rptJobRevenue.

»