question 2

Derver Bookstore is the bookstore on campus for students and faculty. The bookstore shows the following sales profections in units by quarter for the upcoming year: (Click the icon to view the unit sales projoctions.) Fifl (Click the icon to viow the average pnco information) Requirement Prepare a sales budget for the upcoming year by quarter for the Demver Booktone, whth tales categorized by the four product grouipings fbooks, school supplies, apparel, and miscellanoous) Complete the sales budget, one product at a 5me. Denver Bookstore is the bookstore on campus for students and laculty. The bookstoce shows the following sales projections in units by quarter for the upcoming year: (Click the ican to view the aversge price informacon) (Click the icon to view the unit sales projoctions.) Requirement Prepare a salos budget for the upcoming year by quarter for the Demer Bookstore, nith salos categorizod by the four product groupinys (bosks, school supplits, appare, and miscellanecus) Data table Data table The average price of an item in each of the departments is as follows: LaChut Corporation has found that 70% of its sales in any given month are credit sales, while the remaindor are cash sales. Of the credi sales, LaChut Corporation has exporlenced the following collection partern: November sales for last year were $5,000, whle December sales were $115,000 Projected sales for the next three months are as follows: 25% received in the month of the sale 50% recolved in the month aflec the sale 24% received two months after the sale 1% of the credit sales are never recelved Requirement Prepare a cash collectiona budget for the first quarter, with a column for each month and for the quarter. (Round your answors to the nearest whole dollar.)