Question: please answer in this format this was all the i formation we were given Hurtt's Java Seeds is an independent roaster of specialty coffee beans.




Hurtt's Java Seeds is an independent roaster of specialty coffee beans. During March, the company plans to sell 11,000 pounds of beans at $13 per pound. Internet sales account for 55 percent of total sales and are paid for by customers when they place their orders. Of the remaining 45 percent, three-fifths are paid for in the month of sale and two-fifths in the month following the sale. In February, roasted coffee bean sales are expected to total $99,800. The company budgets 2 months ahead, so that in early January, it is time to plan for March. During March, the company plans to sell 14,000 pounds of beans. At the end of February, the company expects to have 4,000 pounds of raw green coffee beans fcosting $5,700) and 870 pounds of roasted beans (costing $4,600) in inventory. Hurtt's would like to have 1,300 pounds of green coffee beans and 540 pounds of roasted beans in inventory at the end of March. Hurtt's purchases green coffee beans from the grower at $2 per pound and sells the roasted beans for $13 per pound. Hurtt's roasters hold 26 pounds of green coffee beans. It takes 19 minutes to roast the beans to perfection. Because the roaster must be monitored by an employee at all times, each batch requires 0.28 direct fabor hours. During the roasting process, the green beans lose 20% of their weight, so that 1.25 pounds of green (raw) beans must be used to produce 1 pound of roasted beans. The standard direct labor rate is $13 per direct labor hour. Variable overhead is apolied at the rate of $83 per direct labor hour, and fixed overhead is budgeted at $13,500 per month, including $1,500 in equipment depreciation. Hurtt's pays for 47 percent of its green coffee beans in the month of purchase and the remaining 53 percent in the month following the purchase. February's purchases of green coffee beans are expected to total $25,300. Variable selling and administrative expenses are 26 percent of sales, and fixed administrative expenses are $35,000 per moath. Both are paid in the month incurred, as are direct labor costs and manufacturing overhead, in March. Hurtt's must make a $31,000 payment on its long-term loan, of which $5,100 is interest. At the end of February, Hurtt's cash balance is expected to be $14.200. The company must maintain a minimum cash balance of $12,000 as a condition of a long term loan. Any cash required to maintain the minimum balance can be borrowed in $1,000 increments at 316 percent annusl interest rate. Interest is paid oniy when principal is repaid. However, it is accrued at the end of everymonth Prepare Hurtt's cash receipts budget for March. (Round answers to O decimal places, e.3. 1250.) Prepare Hurtt's cash payments for purchases budget for March.(Round answers to 0 decimal places, eg. 12 . Prepare Hurtt's cash budget for March. (Round answer to O decimal ploces, es. 125 and enter amounts with negotive sign) Hurtt's Java Seeds is an independent roaster of specialty coffee beans. During March, the company plans to sell 11,000 pounds of beans at $13 per pound. Internet sales account for 55 percent of total sales and are paid for by customers when they place their orders. Of the remaining 45 percent, three-fifths are paid for in the month of sale and two-fifths in the month following the sale. In February, roasted coffee bean sales are expected to total $99,800. The company budgets 2 months ahead, so that in early January, it is time to plan for March. During March, the company plans to sell 14,000 pounds of beans. At the end of February, the company expects to have 4,000 pounds of raw green coffee beans fcosting $5,700) and 870 pounds of roasted beans (costing $4,600) in inventory. Hurtt's would like to have 1,300 pounds of green coffee beans and 540 pounds of roasted beans in inventory at the end of March. Hurtt's purchases green coffee beans from the grower at $2 per pound and sells the roasted beans for $13 per pound. Hurtt's roasters hold 26 pounds of green coffee beans. It takes 19 minutes to roast the beans to perfection. Because the roaster must be monitored by an employee at all times, each batch requires 0.28 direct fabor hours. During the roasting process, the green beans lose 20% of their weight, so that 1.25 pounds of green (raw) beans must be used to produce 1 pound of roasted beans. The standard direct labor rate is $13 per direct labor hour. Variable overhead is apolied at the rate of $83 per direct labor hour, and fixed overhead is budgeted at $13,500 per month, including $1,500 in equipment depreciation. Hurtt's pays for 47 percent of its green coffee beans in the month of purchase and the remaining 53 percent in the month following the purchase. February's purchases of green coffee beans are expected to total $25,300. Variable selling and administrative expenses are 26 percent of sales, and fixed administrative expenses are $35,000 per moath. Both are paid in the month incurred, as are direct labor costs and manufacturing overhead, in March. Hurtt's must make a $31,000 payment on its long-term loan, of which $5,100 is interest. At the end of February, Hurtt's cash balance is expected to be $14.200. The company must maintain a minimum cash balance of $12,000 as a condition of a long term loan. Any cash required to maintain the minimum balance can be borrowed in $1,000 increments at 316 percent annusl interest rate. Interest is paid oniy when principal is repaid. However, it is accrued at the end of everymonth Prepare Hurtt's cash receipts budget for March. (Round answers to O decimal places, e.3. 1250.) Prepare Hurtt's cash payments for purchases budget for March.(Round answers to 0 decimal places, eg. 12 . Prepare Hurtt's cash budget for March. (Round answer to O decimal ploces, es. 125 and enter amounts with negotive sign)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
