Tina's Fine Juices is a bottler of orange juice located in the Northeast. The company produces bottled orange juice from fruit concentrate purchased from suppliers in Florida, 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. The amount of labor required is very small per bottle of juice. The average worker can process 10 bottles of juice per minute, or 600 bottles per hour. The juice is sold by a number of grocery stores under their store brand name and in smaller restaurants, delis, and bagel shops under the name of Tina's Fine Juices. Tina's has been in business for several years and uses a sophisticated sales forecasting model based on previous sales, expected changes in demand, and economic factors affecting the industry. Sales of juice are highly seasonal, peaking in the first quarter of the calendar year.

Forecasted sales for the last two months of 2004 and all of 2005 are as follows:

2004. Bottles

November375,000

December370,000

2005. Bottles

January350,000

February425,000

March400,000

April395,000

May375,000

June350,000

July375,000

August385,000

September395,000

October405,000

November400,000

December365,000

Following is some other information that relates to Tina's Fine Juices:

A. Juice is sold for $1.05 per 12-ounce bottle, in cartons that hold 50 bottles each.

B. Tina's Fine Juices tries to maintain at least 10 percent of the next month's estimated sales in inventory at the end of each month.

C. The company needs to prepare two purchases budgets: one for the concentrate used in its orange juice and one for the bottles that are purchased from an outside supplier. Tina's has determined that it takes 1 gallon of orange concentrate for every 32 bottles of finished product. Each gallon of concentrate costs $4.80. Tina's also requires 20 percent of next month's direct material needs to be on hand at the end of the budget period. Bottles can be purchased from an outside supplier for $0.10 each.

D. Factory workers are paid an average of $15 per hour, including fringe benefits and payroll taxes. If the production schedule doesn't allow for full utilization of the workers and machines, one or more workers are temporarily moved to another department.

E. Most of the production process is automated, the juice is mixed by machine, and machines do the bottling and packaging. Overhead costs are incurred almost entirely in the mixing and bottling process. Consequently, Tina's has chosen to use a plantwide cost driver (machine hours) to apply manufacturing overhead to products.

F. Variable overhead costs will be in direct proportion to the number of bottles of juice produced, but fixed overhead costs will remain constant, regardless of production. For budgeting purposes, Tina's separates variable overhead from fixed overhead and calculates a predetermined overhead rate for variable manufacturing overhead costs.

g. Variable overhead is estimated to be $438,000 for the year, and the production machines will run approximately 8,000 hours at the projected production volume for the year (4,775,000 bottles). The estimated machine hours are 80 percent of capacity for the five machines. Therefore, Tina's predetermined rate for variable overhead is $54.75 per machine hour ($438,000/8,000 machine hours.

ina's has also estimated fixed overhead to be $1,480,000 per year ($123,333 per month), of which $1,240,000 per year ($103,333 per month) is depreciation on existing property, plant, and equipment.

h. All of the company's sales are on account. Based on the company's experience in previous years, the company estimates that 50 percent of the sales each month will be paid for in the month of sale. The company also estimates that 35 percent of the month's sales will be collected in the month following sale and that 15 percent of each month's sales will be collected in the second month following sale.

i. Tina's has a policy of paying 50 percent of the direct material purchases in the month of purchase and the balance in the month after purchase. Variable Overhead costs are also paid 50 percent in the month they are incurred and 50 percent in the following month.

j. The company plans to buy some new machinery in February 2005 at a cost of $75,000. The equipment will have a useful life of 10 years and uses straight line depreciation. The company also plans on paying a dividend of $50,000 in January 2005. Tina's also desires to maintain a cash balance of at least $50,000 at the end of any month. If the projected cash balance is less than that, a line of credit at first national bank will be used to make up the shortage. If the company draws on the line of credit is used, money is borrowed at the beginning of the month. Repayments are made at the end of months in which there is sufficient excess cash (over $50,000) to pay back the entire line of credit. Last, but not least, Tina pays estimated income taxes on a quarterly basis (in March, June, September and December) on the income earned during the respective quarter. The company estimates that its total liability (federal and state) is around 35 percent of taxable income.

k. Selling and administrative expenses are $100,000 per month and are paid in cash as they are incurred.

Required

A. Prepare sales budget for the first quarter of 2005

B. Prepare production budget for the first quarter of 2005

C. Prepare purchases budget for the first quarter of 2005

D. Prepare direct labor budget for the first quarter of 2005

E. Prepare overhead budget for the first quarter of 2005

F. Prepare cash receipts and disbursements budgets for the first quarter of 2005