The DMV

The Division of Motor Vehicles (DMV) is part of the State Department of Transportation (DOT). The purpose of that department is to ensure the safety and free flow of people and goods throughout the State by ensuring that there is a reliable system of transportation and motor vehicle services. This mission is accomplished by funding the maintenance of the existing transportation infrastructure, by adding to and improving the infrastructure, and by otherwise operating a transportation system that minimizes congestion and promotes safety and the economic growth of the State. Among the key functions served by the DOT are:

● driver licensing and insurance

● vehicle inspection

● bridge and highway construction and maintenance

● public transit The current year budget for the DOT is $874 million.

Of that amount, $96 million is budgeted to be spent on the DMV, which has the following objectives:

● to provide customer-friendly, efficient motor vehicle services;

● to regulate drivers and motor vehicles to deter unlawful acts and protect the public safety;

● to further protect public safety by identifying vehicle safety problems; and

● to further protect the public by ensuring that all drivers carry insurance. T he State is currently preparing its budget for the coming fiscal year, which runs from September 1 through August 31.

As the director of the DMV, you are responsible for three major areas:

● licensing, registration, and inspection of motor vehicles;

● driver licensing; and

● compulsory insurance.

A major issue for the coming year will be the overhaul of the driver’s license program to include the latest enhanced digitized security technology. To cover this increased cost, the DMV is planning to charge $5 more for new drivers’ licenses and license renewals. This charge is not enough to fully cover the cost of the new licenses, but raising fees was a political hot potato during the last session of the state assembly, and the Governor would be reluctant to propose any further increase to that fee. Another major initiative being planned for the DMV for the coming year is a centralized computer system to verify that all registered vehicles are insured. Once the system is in place, the DMV will be able to check insurance coverage not only when a vehicle is registered, but also when law enforcement officers stop a vehicle, when the vehicle has its biannual safety inspection, and at other times. The system will require an initial capital investment of $3 million and operating costs of $1.30 per inquiry. It is expected that there will be 1 million uses of the system spread evenly during the coming year. None of the capital investment cost appears as part of the operating budget for the coming year. To comply with the State’s 2011 Clean Air Act, the auto inspection program must be modified. The DMV has estimated that it will cost $7.2 million to equip the state vehicle testing centers with the necessary equipment for the new, stricter test. None of this cost will be part of the operating budget for the DMV. The DMV also expects to issue more licenses per month early in the year, as drivers try to avoid the extra cost and documentation requirements associated with the new higher security licenses. It expects to issue 923,456 licenses using the old technology, spread evenly throughout the first four months of the year, and 843,023 licenses using the new digitized technology, spread evenly throughout the last eight months of the year. There are expected to be 342,587 vision tests, 847,129 written driving tests, and 429,222 road tests in total for the year. These tests are expected to occur in the same proportion as the number of licenses issued each month. It is expected that there will be 962,135 vehicle registrations and 1,106,455 annual vehicle inspections, and these will occur evenly throughout the year. Note that the vehicle inspection number includes re-inspections for vehicles that fail their initial inspection.

The sources of revenue for the DMV are as follows:

● auto license fees: $25 for the old-style license and $30 for the new improved digitized license with all security features;

● vehicle registration fees: $53 per vehicle registered, on average;

● vehicle inspection fees: $35 for failing the inspection—otherwise no fee. It is expected that 15 percent of the total number of vehicle registrations will result in inspection failures and re-inspections;

● state appropriation—for any balance not funded by fees; and

● transportation trust fund—for capital acquisitions.

The costs of running your department consist of personnel expenses, materials and supplies, and a variety of purchased services. Personnel costs have a fixed administrative component of $6.5 million per year that is not affected by the DMV’s service volume. Administrators are paid evenly throughout the year. Other personnel costs average $2 per transaction, regardless of transaction type, including issuance of an auto license, vehicle registration, vehicle inspection, or administration of any type of test. Materials and supplies cost $.30 per transaction. These costs are incurred each month in direct relation to the number of transactions for the month. The $2 personnel and $.30 materials and supplies cost per transaction are not required for insurance inquiries. Other departmental overhead costs include heat, electricity, and rent. Those costs are fixed at $8 million, and are paid evenly throughout the year.

Additionally, the DMV pays outside contractors on the following fee schedule:

● $17 per vehicle inspected

● $2 per vision test

● $15 per road test

● $5 per written test

● $25 per license plate (30 percent of all vehicle registrations require new license plates)

● $10 per driver’s license (old style) and $37 per license (new digitized licenses) The director of the DOT is hoping that DOT’s financial situation will allow for expanded subsidies of public transportation. As such, she is hoping that each division of the DOT will at least break-even, if not show a profit. Although you realize that the DMV will receive a state subsidy to operate if needed, you know that your boss would be unhappy if such a subsidy is needed for your division. Using a computer spreadsheet, prepare a budget for the DMV for the coming year, based on the information you currently have. If the budget shows a deficit, you may need to make some adjustments, so use formulas for your calculations. That way you will be able to make changes in your worksheet and easily calculate updated results. Specifically, 1. Prepare a monthly operating budget for the DMV for the fiscal year ending August 31. Determine the operating surplus and deficit for each month and for the year as a whole. Use one page or worksheet in your spreadsheet to list all of the base information, and another for the operating budget. [Hint: It may be easier to prepare the budget if you add a third page or worksheet to calculate the number of transactions each month.

(Please use excel and show the equations)

Blue Bird Corporation has the following inventory items and costs for the month.
1 unit purchased Jan 15 at a cost of $50.
1 unit purchased Jan 20 at a cost of $54.
1 unit purchased Jan 24 at a cost of $56
On January 26, the company sold 2 units for $70 each. The company uses the LIFO (Last In First Out) inventory method.
a. What is the Cost of Goods Sold for the month? $
b. What is Gross Margin for the month? $
c. What is ending inventory for the month? $

2. Framer Inc. has the following inventory items and costs for the month.
1 unit purchased Jan 15 at a cost of $60.
1 unit purchased Jan 20 at a cost of $45.
1 unit purchased Jan 24 at a cost of $54
On January 26, the company sold 2 units for $70 each. The company uses the Weighted Average inventory method.
a. What is the Cost of Goods Sold for the month? $
b. What is Gross Margin for the month? $
c. What is ending inventory for the month? $

Problem 1: Record the Journal Entry or Entries for the following transactions assuming a perpetual inventory system is used.

1. XYZ Corp. is a retailer and they purchase 10,000 books for $25,000 dollars on account from ABC Corp.

2. Assume the terms of the sale described in #1 are FOB shipping point, XYZ Corp. pays Just-In-Time Logistics $2,200 for shipping.

3. XYZ Corp. purchases 3,600 calculators for $130,000 dollars from ABC Corp. under the terms 2/10, n/30 on March 1, 20X5. On March 8, 20X5 XYZ Corp. paid ABC Corp. in full.

4. XYZ Corp. purchases 300 keyboards from ABC Corp. for $24,000 on account on October 5, 20X4. On October 17, 20X4 XYZ Corp. discovered that $800 of the calculators (from the purchase in #3) were defective and returned them to ABC Corp.

5. XYZ Corp. sells 500 pencil cases to ABC Corp. at a selling price of $12, the cases had an original cost of $8.

6. Assume that after the sale described in #5 ABC Corp. returned 25 pencil cases to XYZ Corp. Assume the cases are still like new and XYZ places them back into inventory.

7. On April 15, 20X4, XYZ Corp. sells 500 cases of staples to State University on account for $1,500 with the payment terms 2/10, n/30 and the staples had a cost of $925. State University pays XYZ Corp. in full on April 24, 20X4.

Leading Indicators and Lagging Indicators both play an important role in Performance Evaluation. From the various indicators covered in this module (or other measures not addressed in the module), select four that serve a lagging indicators and four that serve as leading indicators, and briefly defend your choice. (Note: identify one leading and lagging indicator for each category shown below. Financial - Common Size Analysis. Lagging Indicator Leading Indicator Financial - Ratio Analysis. Lagging Indicator Leading Indicator Balanced Scorecard – Internal Business Processes. Lagging Indicator Leading Indicator Balanced Scorecard – Learning & Growth. Lagging Indicator Leading Indicator?

Exercise 12-3

Hillsong Inc. manufactures snowsuits. Hillsong is considering purchasing a new sewing machine at a cost of $2.45 million. Its existing machine was purchased five years ago at a price of $1.8 million; six months ago, Hillsong spent $55,000 to keep it operational. The existing sewing machine can be sold today for $ 240,438 . The new sewing machine would require a one-time, $85,000 training cost. Operating costs would decrease by the following amounts for years 1 to 7:

The new sewing machine would be depreciated according to the declining-balance method at a rate of 20%. The salvage value is expected to be $ 379,100 . This new equipment would require maintenance costs of $ 94,000 at the end of the fifth year. The cost of capital is 9%.

Click here to view PV table.

Use the net present value method to determine the following: (If net present value is negative then enter with negative sign preceding the number e.g. -45 or parentheses e.g. (45). Round present value answer to 0 decimal places, e.g. 125. For calculation purposes, use 5 decimal places as displayed in the factor table provided.)

Calculate the net present value.

Determine whether Hillsong should purchase the new machine to replace the existing machine?

With our understanding of revenue recognition lets see how we might apply the 5 step model to the following transaction that most of us have encountered. Lets say we visit our favorite phone store and sign up for new cell service. We sign up for and receive a new phone that would normally retail for $500 (cost to manufacture $380). We commit to a three year contract where we will have to pay back an amount that starts at $600 (to pay for the phone) but drops each month until it reaches zero at the end of 3 years (kind of like financing for the phone). We pay an activation fee of $35 along with the first month of service that will be $70 each month for the next 36 months. After one year of service, we will be eligible for $100 off the latest phone if we trade in the one year old phone for a new one. That rises to $200 after two years. You can describe how to apply the 5 step model to this transaction from the phone company side. Show journal entries when necessary to make sure this gets recorded (you do not have to show all of them just enough to get the idea).

Question 4

Fresplanade Co. had the following historical collection pattern for its credit sales:

75% collected in the month of sale
12% collected in the first month after month of sale
9% collected in the second month after month of sale
3% collected in the third month after month of sale
1% uncollectible

The sales on open account (credit sales) have been budgeted for the last six months of the year as shown below:

The estimated total cash collections by Fresplanade Co. during November from collection of accounts receivable is:

Multiple Choice

• $131,940.

• $120,060.

• $177,300.

• $154,800.

• $121,320.

Fresplanade Co. had the following historical collection pattern for its credit sales:

75% collected in the month of sale
12% collected in the first month after month of sale
8% collected in the second month after month of sale
4% collected in the third month after month of sale
1% uncollectible

The sales on open account (credit sales) have been budgeted for the last six months of the year as shown below:

The estimated cash collection by Fresplanade Co. during August from July and August credit sales is:

Multiple Choice

• $98,850.

• $94,380.

• $102,090.

• $65,250.

• $84,690.

Six Measures of Solvency or Profitability

The following data were taken from the financial statements of Gates Inc. for the current fiscal year.

Assuming that total assets were $2,514,000 at the beginning of the current fiscal year, determine the following. When required, round to one decimal place.

period costs are: costs expensed on the income statement when incurred, are added to the cost of the inventory, include direct labor, are equal to the product costs?

how price discrimination can generate more revenue

Hamilton Ltd. was organized on January 2, 2017. The following investment transactions and events occurred during the following months:

Assume that Hamilton has a significant influence over Wong with its 20% share.

Required:
1. Prepare the entries to record the preceding transactions in Hamilton’s books. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.)



2. Calculate the carrying value per share of Hamilton’s investment as reflected in the investment account on January 4, 2019. (Round your answer to 2 decimal places.)



3. Calculate the change in Hamilton’s equity from January 2, 2017, through January 5, 2019, resulting from its investment in Wong.

Green Mountain Coffee Roasters is a specialty coffee roaster and manufacturer of coffee makers. Using the following information, class notes, and the posted PowerPoint slides as resources complete the following:

I. Constructing a Balance Sheet 1. Use the information below to construct and balance sheet and a common sized balance sheet for the corporation (note the information here is not necessarily provided in the order in which it should appear on a balance statement. a. Gross fixed assets: $110,000 b. Cash $100,000 c. Accounts payable: $43,000 d. Retained earnings: $25,000 e. Accumulated depreciation $42,000 f. Accounts receivable $75,000 g. Long-term bank loan $29,000; $15,000 of which will be due within the next 12 months. h. Mortgage (long-term) $50,000 i. Common Stock $105,000 j. Inventories $36,000 k. Notes payable (short-term) $27,000 2. What is the firm's net working capital? (the difference between current assets and current liabilities). 3. Does the firm use more equity or debt (as a percent of total assets) to finance its business? • A common-sized balance sheet is a balance sheet in which a firm's assets and sources of debt and equity are expressed as a percentage of its total assets. • The debt ratio- is a firm's total liabilities divided by its total assets. It is a ratio that measures the extent to which a firm has been financed with debt. Use the following to answer questions 29-37:

Use the information and your calculations from the Balance Sheet and Statement of Cash Flows exercise posted on Canvas to answer the following questions:

34. The corporation had cash flow from operating activities of: A) $9,000 B) $21,000 C) $33,000 D) $59,000

35. The corporation had cash outflow from investing activities of: A) $38,000 B) $35,000 C) $3,000 D) $0

36. The corporation had cash flow from financing activities of: A) $35,000 B) $32,000 C) $3,000 D) $49,000 Page 8

37. The corporation's cash _______________ by __________________. A) increased, $30,000 B) increased, $18,000 C) decreased, $30,000 D) decreased $18,000

identify three factors that would discourage you from selecting a target company to acquire or partner with and why these factors are likely to work against a merger or acquisition.

The Lippert Company uses the perpetual inventory system. The following July data are for an item in Lippert's inventory:

Calculate the cost of goods sold for the July 15 sale using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost methods.

Round your final answers to the nearest dollar. For weighted-average cost, do not round the weighted-average unit cost