Tina's Fine Juices is a bottler of orange juice. The company produces bottled orange juice from fruit concentrate purchased from suppliers in Arizona and California. The only ingredients in the juice are water and concentrate. The juice is blended, pasteurized and bottled for sale in 12 ounce plastic bottles. The process is heavily automated and is centered on five machines that control the mixing and bottling of the juice. Each machine is run by one employee and can process 10 bottles of juice per minute, or 600 bottles per hour. The juice is sold by several grocery stores under their store brand name and in smaller restaurants, delis, and bagel shops. Tina has been in business for several years and uses a sophisticated sales forecasting model based on prior sales, expected changes in demand, and economic factors affecting the industry. Sales of juice are highly seasonal, peaking in the first quarter of the year. Forecasted sales, in bottles, for the first quarter are as follows: January February March 250,000 325,000 450,000 Tina sells the juice for $1.05 per bottle, in cases of 50 bottles. In proper order and form, project a sales budget for the in quarter. January February March 1 Qer Forecasted Units Unit Selling Price Budgeted Sales Budget EOC Production Budget Tina tries to maintain at least 10% of next month's sales forecast in inventory at the end of each month. Because sales have been projected to increase dramatically, the company does not want to run the risk of running out of juice to customers. The beginning inventory for January was 25,000 bottles, and April sales are forecasted at 500,000 bottles. In proper order and form, project a production budget for the lat quarter. Assume all of the information from the sales budget still applies. (ROUND ALL CALCULATIONS TO THE NEAREST WHOLE DOLLAR) January February March 1* Qtr Budgeted Sales (Units or $) ? Desired Ending Inventory Total Production Needs Less: Beginning Inventory Required Production