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

Determine the predetermined overhead rate.

Determine the total number of drones to account for.

Prepare an equivalent unit's schedule. The schedule should follow the format above.

Determine the started and completed units by using the following formula:

Started $-$ Ending $=$ Completed and Transferred Out $-$ Beginning

Calculate the total cost of aluminum and the cost per equivalent unit for the direct material aluminum.

Calculate the total cost and the cost per equivalent unit for the direct materials motor and propellers.

Determine the total conversion cost by using the predetermined rate and the direct labor rate. Then determine the conversion cost per drone.

Determine the unit cost per drone $($Material cost per unit plus Conversion Cost per unit$).$

Prepare a Cost of Production report. This report should show all costs transferred into Work$-$inProcess and the costs transferred to Finished Goods $($COGM$)$ by using the Equivalent Units Schedule. This process uses FIFO costing.

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$)$ Show and calculate an Income Statement

f$)$ Gross ProfitManufacturing Process Information

antemand.

propellers are dided iook as the last ates in the proveis.

Cerverilon couts are added equally throughout the process. Comersien is SWS complete for the

begineing inventery work in proceis ind $45x$ complete for the endine inwempory werk in procest.

for enerthead.

The following infermantion is wallable concemine the drect muberiah.

Dorect Materialy Nhaniom

Beginning ineestery

Rurchane of slumisula

thding linembory

One pound of aty

$0$ pellints e $52$ as a sound

$4,000$ pounds of letlets $8$ is $2$ t a pound

$200$ pounds of selles o $52.$st a pound

Eesinening imemiory

hurchuse of pospeliens

Ending Progeliers

$0$ preveliers o $$0\mathrm{.}10$ a propellyr

$360$ prapelen $89\mathrm{.}10$ a proseller

Dereat Muterials Motor

Beginine inventory moters

Punchase of entory

rindinemoters

The work in process account has the following inlormation

Beginning Work in Process containd $0$ drones.

Ending werk is peceis contains MOS drents

Brginine Finivhed Goods costaint $Q$ drones

$12,000$ drones were sold at $539$ each

Tau kuse is $3$ss$.$