I just need help on that single cell in c1, and all of c2. I beg of you.

Jasper Fruits Corporation wholesales peaches and oranges. Barbara Jasper is working with the company's accountant to prepare nex year's budget. Ms. Jasper estimates that sales will increase 4 percent for peaches and 9 percent for oranges. The current year's sales revenue data follow. Based on the company's past experience, cost of goods sold is usually 65 percent of sales revenue. Company pollcy is to keep 15 percent of the next period's estimated cost of goods sold as the current period's ending inventory. (Hint Use the cost of goods sold fc. the first quarter to determine the beginning inventory for the first quarter.) Required o. Prepare the company's sales buidget for the next year for each quarter by individual product. b. If the selling and administrative expenses are estimated to be $680,000, prepare the company's budgeted annual income statement: c. Ms. Jasper estimates next year's ending inventory will be $35,800 for peaches and $57,700 for oranges. Prepare the company's inventory purchases budgets for the next year, showing quarterly figures by product. If the selling and administrative expenses are estimated to be $680,000, prepare the company's budgeted annual income statement. Prepare the company's sales budget for the next year for each quarter by indluldual product. Complete thav question by entering your answers in the tabs below. Ms. Jasper estimates next year's ending inventory will be 35.800 for peaches. Prepare the company's inventon budgets for the next vear, showing quarterly figures by product. SRound your final ansivers to nearest whole dol Ms. Jasger estimates next year s ending imventocy will be $57,700 for aranpes. Prepore the tompany'sinucotory purchases