Part Two Instructions

Using a spreadsheet and based on the information provided in the next section, complete the following requirements:

$1.$ Determine the predetermined overhead rate.

$2.$ Determine the total number of mini sport balls to account for.

$3.$ Prepare an equivalent unit's schedule. The schedule should follow the format below; you may add additional information if you would like.

$4.$ Determine the total costs for the plastic pellets and the unit plastic pellet cost for the balls.

$5.$ Determine the total costs for the ink and printing of the logo and the unit cost for the logo for each ball.

$6.$ Determine the total conversion cost and the conversion cost per ball.

$7.$ Determine the total equivalent cost per ball.

$8.$ Prepare a Cost of Production report. This report should show all costs transferred into Work$-$inProcess and the costs transferred to Finished Goods. This process uses FIFO costing.

$9.$ Determine the amounts for the following.

a$)$ Ending Work$-$in$-$Process Inventory in Units AND Dollars

b$)$ Ending Finished Goods Inventory in Units AND Dollars

c$)$ Cost of Goods Sold

d$)$ Over$/$Under Applied Manufacturing Overhead

e$)$ Gross Margin

f$)$ Tax Amount

g$)$ Net Income

$10.$ Prepare the necessary Journal Entries related to the manufacturing cycle for this accounting period. Prepare journal entries for the accounting period. Use the account numbers in the chart of accounts, below, instead of the accounts names when writing journal entries.

CHART OF ACCOUNTS

Chart of Accounts

Assets

Cash

Accounts Receivable

Raw Materials $-$ Plastic Pellets

Raw Materials $-$ Ink

Work in Process

Factory Overhead

Finished Goods

Liabilities

Accounts Payable

Wages Payable

Revenues

Sales

Expenses

COGS

Journal Entries

Account Numbers

$10000$

$11000$

$12000$

$12100$

$15000$

$15050$

$16000$

$20000$

$21000$

$40000$

$50000$

a$.$ In the first journal entry record the purchase of plastic pellets and the ink materials using cash and combine it in one journal entry.

b$.$ Record the materials, plastic pellets and ink, transferred to WIP. Again, use one journal entry to record the transfer of the plastic pellets and ink.

c$.$ Record the direct labor into WIP using Wages Payable.

d$.$ Record the applied FOH.

e$.$ Record the actual FOH using cash.

f$.$ Record the over or under applied FOH

g$.$ Record the sale of the goods on account along with the cost of the inventory that was sold. Combine both into one journal entry. Manufacturing Process Information

Slam, Dunk, Score, Inc. started a small manufacturing plant that manufactures mini sport balls with logos printed on them. The manufacturing process starts by pouring the plastic pellets into molds, melting and forming the balls and then printing the logo onto the balls after they are formed. The printing of the logo will be the last step in the production process. The resulting balls are then sent to quality control and if the inspection is approved, they are transferred to finished goods. This process is completely automated.

Direct material, Plastic Pellets, is added $100\backslash \%$ at the beginning of the process.

Direct material ink, for the logo$,$ is added $\backslash (100\backslash \%\backslash )$ at the end of the process.

Conversion costs are added equally throughout the process. Conversion is $\backslash (40\backslash \%\backslash )$ complete for the beginning inventory work in process and $\backslash (60\backslash \%\backslash )$ complete for the ending inventory work in process.

At the beginning of the accounting period, Slam, Dunk, Score, Inc. started $150,000$ units. The predetermined factory overhead rate is based on an estimated FOH cost of $\backslash (\backslash$$ $7,500\backslash ).$ Overhead is applied to production based on direct labor hours. This information is to be used to determine the application rate for overhead.

Estimated and actual direct labor costs totaled $\backslash (\backslash$$ $7,300\backslash )$ which is calculated at $\backslash (\backslash$$ $7\mathrm{.}30\backslash )$ per hour.

Actual factory overhead costs totaled $\backslash$$$1,050,000.$

Beginning Work$-$in$-$Process costs totaled $\backslash (\backslash$$ $0\backslash )$ since this is the first month of production.

The following information is available concerning direct materials.

Direct Materials$-$Plastic

Beginning inventory

Purchase of Plastic Pellets

Ending Inventory

One pound of plastic makes $100$ balls

Direct Material$-$Ink

Beginning inventory

Purchases of Ink

Ending inventory

One cartridge will print $100$ balls

$0$ plastic pellets @ $\backslash$$$11\mathrm{.}00$ per pound

$1,700$ pounds @ $\backslash (\backslash$$ $11\mathrm{.}00\backslash )$ per pound

$200$ pounds @ $\backslash (\backslash$$ $11\mathrm{.}00\backslash )$ per pound

The Work$-$in$-$Process account has the following information

Beginning Work$-$in$-$Process contains $0$ equivalent units

Ending Work$-$in$-$Process contains $10,000$ equivalent units

The Finished Goods account has the following Information

Beginning Finished Goods contains $0$ balls

Ending Finished Goods contains $1,000$ balls

The selling price is $\backslash (\backslash$$ $10\backslash )$ per ball and $139,000$ balls were sold

Selling and Administrative Costs totaled $\backslash (\backslash$$ $70,000\backslash )$; tax rate is $\backslash (30\backslash \%\backslash )$