Mobile Security, Inc. (MSI) has been an audit client of Leo
& Lee, LLP for the past 12 years. MSI is a small, publicly
traded aviation company based in Cleveland, Ohio, where it
manufactures high-tech unmanned aerial vehicles (UAV), also known
as drones, and other surveillance and security equipment. MSI’s
products are primarily used by the military and scientific research
institutions, but there is growing demand for UAVs for commercial
and recreational use. MSI must go through an extensive bidding
process for large government contracts. Because of the sensitive
nature of government contracts and military product designs, both
the facilities and records of MSI must be highly secured.
In October 2022, MSI installed a new cloud-based inventory costing
system to replace a system that had been developed in-house. The
old system could no longer keep up with the complex and detailed
manufacturing costing process that provides information to support
competitive bidding. MSI’s IT department, together with the
consultants from the software company, implemented the new
inventory costing system which went live on December 1, 2022. Key
operational staff and the internal audit team from MSI were
significantly engaged in the selection, testing, training, and
implementation stages.
The inventory costing system uses various manufacturing costing and
unit of production inputs to calculate and produce a database of
all product costs and recommended sales prices. It also integrates
with the general ledger each time there are product inventory
movements such as purchases, sales, waste, and damaged inventory
losses.
The following list of sales invoices are entered in the sales
journal for the months of June 2023 and July 2023, respectively.
All goods are shipped FOB shipping point.
Sales Invoice Amount |
Sales Invoice Date |
Cost of Merchandise Sold |
Date Shipped |
||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
June |
|||||||||||
a. |
$30,000 | June 21 | $20,000 | June 29 | |||||||
b. |
20,000 | June 30 | 8,000 | June 20 | |||||||
c. |
10,000 | June 29 | 6,000 | June 30 | |||||||
d. |
40,000 | June 30 | 24,000 | July 3 | |||||||
e. |
100,000 | June 30 | 56,000 | June 30 | (shipped to consignee) | ||||||
July |
|||||||||||
f. |
$60,000 | June 30 | $40,000 | July 1 | |||||||
g. |
40,000 | July 2 | 23,000 | July 1 | |||||||
h. |
80,000 | July 3 | 55,000 | June 30 |
Analysis and evaluation: Analyze the eight
transactions shown above. Based on a sales cutoff analysis, record
necessary adjusting journal entries at June 30 in connection with
the foregoing data.
List of Accounts
Date |
Account Titles and Explanation |
Debit |
Credit |
---|---|---|---|
June 30 |
|||
(To record the revenues) |
|||
June 30 |
|||
(To record the cost of goods sold) |
Get Answers For Free
Most questions answered within 1 hours.