Hurtt's Java Seeds is an independent roaster of specialty coffee beans. The company budgets two months ahead, so that in early January, it is time to plan for March. During March, the company plans to sell 10,330 pounds of beans at $12 per pound. At the end of February, the company expects to have 2,050 pounds of raw green coffee beans (costing $4,100 ) and 720 pounds of roasted beans (costing $3,600 ) in inventory. Hurtt's would like to have 1,780 pounds of green coffee beans and 460 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 $12 per pound. Hurtt's roasters hold 25 pounds of green coffee beans. It takes 15 minutes to roast the beans to perfection. Because the roaster must be monitored by an employee at all times, each batch requires 0.25 direct labor 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 one pound of roasted beans. The standard direct labor rate is $12 per direct labor hour. Variable overhead is applied at the rate of $80 per direct labor hour, and fixed overhead is budgeted at $14,900 per month, including $1,880 in equipment depreciation. Internet sales account for 50 percent of total sales and are paid for by customers when they place their orders. Of the remaining 50 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 $98,020. Hurtt's pays for 40 percent of its green coffee beans in the month of purchase and the remaining 60 percent in the month following the purchase. February's purchases of green coffee beans are expected to total $25,000 whereas March purchasest green coffee beans are expected to total $24,636. Variable selling and administrative expenses are 20 percent of sales, and fixed administrative expenses are $31,020 per month, Both are paid in the month incurred, as are direct labor costs and manufacturing overhead. In March. Hurtt's must make a $31,890 payment on its long-term loan, of which $5,570 is interest. At the end of February. Hurtt's cash balance is expected to be $14,070. 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 a 12 percent annual interest rate. Interest is paid only when principal is repaid. However, it is accrued at the end of every month. Prepare the March pro-forma income statement and balance sheet for Hurtt's Java Seeds (ignore income taxes). (If an amount reduces the account balance then enter with negative sign preceding the number e.g. -45 or parentheses e.g. (45). Prepare the March pro-forma income statement and balance sheet for Hurtt's Java Seeds (ignore income taxes). (If an amount reduces the account balance then enter with negative sign preceding the number e.g. -45 or parentheses e.g. (45).) Balance sheet Assets Total Assets Liabilities $ Total Assets Liabilities Total Liabilities Total Liabilities and Equity Hurtt's Java Seeds is an independent roaster of specialty coffee beans. The company budgets two months ahead, so that in early January, it is time to plan for March. During March, the company plans to sell 10,330 pounds of beans at $12 per pound. At the end of February, the company expects to have 2,050 pounds of raw green coffee beans (costing $4,100 ) and 720 pounds of roasted beans (costing $3,600 ) in inventory. Hurtt's would like to have 1,780 pounds of green coffee beans and 460 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 $12 per pound. Hurtt's roasters hold 25 pounds of green coffee beans. It takes 15 minutes to roast the beans to perfection. Because the roaster must be monitored by an employee at all times, each batch requires 0.25 direct labor 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 one pound of roasted beans. The standard direct labor rate is $12 per direct labor hour. Variable overhead is applied at the rate of $80 per direct labor hour, and fixed overhead is budgeted at $14,900 per month, including $1,880 in equipment depreciation. Internet sales account for 50 percent of total sales and are paid for by customers when they place their orders. Of the remaining 50 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 $98,020. Hurtt's pays for 40 percent of its green coffee beans in the month of purchase and the remaining 60 percent in the month following the purchase. February's purchases of green coffee beans are expected to total $25,000 whereas March purchasest green coffee beans are expected to total $24,636. Variable selling and administrative expenses are 20 percent of sales, and fixed administrative expenses are $31,020 per month, Both are paid in the month incurred, as are direct labor costs and manufacturing overhead. In March. Hurtt's must make a $31,890 payment on its long-term loan, of which $5,570 is interest. At the end of February. Hurtt's cash balance is expected to be $14,070. 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 a 12 percent annual interest rate. Interest is paid only when principal is repaid. However, it is accrued at the end of every month. Prepare the March pro-forma income statement and balance sheet for Hurtt's Java Seeds (ignore income taxes). (If an amount reduces the account balance then enter with negative sign preceding the number e.g. -45 or parentheses e.g. (45). Prepare the March pro-forma income statement and balance sheet for Hurtt's Java Seeds (ignore income taxes). (If an amount reduces the account balance then enter with negative sign preceding the number e.g. -45 or parentheses e.g. (45).) Balance sheet Assets Total Assets Liabilities $ Total Assets Liabilities Total Liabilities Total Liabilities and Equity