Please solve the case and show all the corresponding answers for the attached excel pictures. I need full answers for all the excel lines$/$tables please!!! Thank you

Previous answer that I got only included partial information that could be inputted into the table along with the ending answer, but I need the table fully filled out.

Marketing and Sales

The forecasted increase in Letsgg's sales can be seen in the company's sales projections presented in Exhibit

Although the weather can have a significant impact on the travel trailer industry $($i$.$e$.,$ hurricane season,

flooding, and even droughts have had negative effects on the sales and rentals of travel trailers$),$ Letsgois

management believes these problems will be mitigated in the future by global warming. All sales

projections are done by Mark Newman in his role as Lettsgo's.president.

The company maintains finished goods inventory on hand at the end of each month equal to $300$ trailers

plus $20\%$ of the next month's projected sales.

Exhibit $1$

Actual and Projected Sales, in Number of Trailers

The sales details for $2024($actual$)$ and $2025($projected$),$ by month, are as follows:

Actual sales in dollars for the last two months of $2024$ and budgeted sales for the first six months

of $2025$ follow:

Past experience shows that $25\%$ of a month's sales are collected in the month of sale, $10\%$ in the

month following the month of sale, and $60\%$ in the second month following the month of sale. The

remainder is uncollectible.

Total other budgeted product costs for wages, heat, light and power, equipment rental, equipment purchases,

depreciation, and the budgeted period costs for selling and administrative for the first four months of $2025$

are given below $($the expenses that required payments are all paid in cash$)$:

The company always finishes all the trailers in process by the end of the month $($no work$-$in$-$process

account$).$ Inventory cost is calculated using the FIFO method. The unit cost of trailers in the beginning

finished goods inventory account in January, $2025$ is $$900.$

Hint: The unit cost for each month equals to the total production costs divided by the number of units

produced during the month.

Required

Prepare production and material purchasing budgets for Letsgo for the first three months of $2025(1^("$st $")$

quarter$).$

$2..$ Prepare the budgeted income statement for Letsgo for the first three months of $2025(1^("$st $")$ quarter$).$

Budget