The following information relates to Emily's Florist Shop at June $30,2020,$ the end of its

first year of operations. $($All purchases were made for cash unless stated otherwise$)$

On July $2,2019,$ Emily purchased equipment for $$14,000.$ The equipment is

expected to have a useful life of $10$ years. The expected residual value is zero,

and Emily will use straight$-$line depreciation.

On August $1,2019,$ a one$-$year insurance policy was purchased for $$1,920.$

On January $1,2020,$ a corporate customer paid $$3,600$ as full payment for a one$-$

year contract for fresh flowers to be delivered to its offices every Monday

morning. At June ${30}^{th},26$ of the required $52$ deliveries had been completed.

On July $2,2019,$ Emily purchased enough supplies to last the entire first year of

operations for $$4,250.$ At June $30,2020,$ Emily counted the supplies on hand

and calculated the cost, which amounted to $$1,435.$

Emily pays her store assistant on alternate Fridays. The last pay day in June

was June ${20}^{th}$ and the first pay day after year end is July $4^{th}.$ The assistant

worked $30$ hours during this period of which $12$ were in July and the rest in June.

The assistant earns $$13\mathrm{.}50$ per hour.

Required:

a$)$ For each transaction, prepare any adjusting entries required at June $30,2020$

b$)$ Emily uses reversing entries. Prepare any reversing entries required for July $1,$

$2020$ Please see attached excel sheet structure and fill it out in a table format with all the rows filled.