Must be done in Excel down load FROM Brightspace

Enter the Adjustments:

Adjastment data:

a$.$ Accrued Salaries Expense, $$1,000.$

b$.$ Depreciation was recorded on the truck using the straight$-$line method. Aspuse a aseful life of five years and a salvage value of $$5,000.$

c$.$ Prepaid Insurance for the month has expired.

d$.$ Office Supplies on hand, $$100.$

e$.$ Uncarned Revenue earned during the month, $$300.$

f$.$ Acerued Service Revenue, $$650.$

Check adjusted Adjustment Bal $=$$$2,850$

Prepart an Adjusted Trial Balance as of December $31,2023.$ Check Adjated Trial Bal $=$ $$52,900$

Prepare Miller Delivery Service's Income Statement and Balance Sheet for the month ended December $31,2023$ with Net Income and Total.

Excel project directions for Miller Delivery Service

Data input:

Enter Data: Carefully input your data into the designated cells, ensuring accuracy and consistency.

To reenter data, use Single cell Referencing

Check for Errors: Review your data for any typos, incorrect values, or missing entries.

Formulas and Calculations:

Calculations:

Utilize basic Excel formulas: adding, subtract, multiply, divide

Basic Functions:

Utilize basic Excel functions like SUM to perform calculations on your data.

Review Results:

Analyze the calculated values.