A1. Computation of inventory budgets by months for prouction in units for April, May and June:
BRIGHTON, INC. | |||
Schedule computing production budget (units) for April, May and June | |||
April | May | June | |
Budgeted Sales | 600,000 | 500,000 | 600,000 |
Inventory required at end of month (25% of next month's sales) | 125,000 (500,000 x 25%) | 150,000 (600,000 x 25%) | 150,000 (600,000 x 25%) |
Total needs | 725,000 | 650,000 | 750,000 |
Less: Inventory on hand at beginning of month | 150,000 | 125,000 | 150,000 |
Budgeted production - units | 575,000 | 525,000 | 600,000 |
A2. Computation of inventory budgets by months for raw materials purchases in pounds for April and May:
Schedule computing Raw materials inventory purchase budget (Pounds) For April and May | |||
April | May | June | |
Budgeted production - units | 575,000 | 525,000 | 600,000 |
Materials required per tile | 0.25 pound | 0.25 pound | 0.25 pound |
Materials needed for production - pounds | 143,750 | 131,250 | 150,000 |
Plus: Ending material inventory | 65,625 (131,250 x 50%) | 75,000 (150,000 x 50%) | |
Total needs | 209,375 | 206,250 | |
Less: Beginning material inventory | 71,875 | 65,625 | |
Budgeted Material purchases - pounds | 137,500 | 140,625 |
B. Projected income statement for May:
BRIGHTON, INC | ||
Projected Income Statement For the Month of May | ||
Gross Sales (500,000 units x $4 per unit) | 2,000,000 | |
Less: Cash discount (2,000,000 x 1%) | 20,000 | |
Bad debt (2,000,000 x 0.50%) | 10,000 | 30,000 |
Net Sales | 1,970,000 | |
Cost of Goods Sold: | ||
Variable manufacturing Costs (500,000 x $2.22) | 1,110,000 | |
Fixed manufacturing costs | 410,000 | 1,520,000 |
Gross profit | 450,000 | |
Selling expense (2,000,000 x 10%) | 200,000 | |
Administrative expense | 160,000 | |
Net Profit | 90,000 |
Cash Budget for the month of May:
May($) | |
Net Profit for May (as per above statement) | 90,000 |
Add: Depreciation on office furniture and fixtures | 160,000 |
Add: Depreciation included in Fixed manufacturing overhead | 190,000 |
Cash available at the end of May | 440,000 |
Brighton, Inc., manufactures kitchen tiles. The company recently expanded, and the controller believes that it will...
Brighton, Inc., manufactures kitchen tiles. The company recently expanded, and the controller believes that it will need to borrow cash to continue operations. It began negotiating for a one-month bank loan of $500,000 starting May 1. The bank would charge interest at the rate of 1.00 percent per month and require the company to repay interest and principal on May 31. In considering the loan, the bank requested a projected income statement and cash budget for May. The following information...
Brighton, Inc., manufactures kitchen tiles. The company recently expanded, and the controller believes that it will need to borrow cash to continue operations. It began negotiating for a one-month bank loan of $400,000 starting May 1. The bank would charge interest at the rate of 0.75 percent per month and require the company to repay interest and principal on May 31. In considering the loan, the bank requested a projected income statement and cash budget for May. The following information...
Brighton, Inc., manufactures kitchen tiles. The company recently expanded, and the controller believes that it will need to borrow cash to continue operations. It began negotiating for a one-month bank loan of $500,000 starting May 1. The bank would charge interest at the rate of 0.75 percent per month and require the company to repay interest and principal on May 31. In considering the loan, the bank requested a projected income statement and cash budget for May. The following information...
Brighton, Inc., manufactures kitchen tiles. The company recently expanded, and the controller believes that it will need to borrow cash to continue operations. It began negotiating for a one-month bank loan of $500,000 starting May 1. The bank would charge interest at the rate of 1.00 percent per month and require the company to repay interest and principal on May 31. In considering the loan, the bank requested a projected income statement and cash budget for May. The following information...
Brighton, Inc., manufactures kitchen tiles. The company recently expanded, and the controller believes that it will need to borrow cash to continue operations. It began negotiating for a one-month bank loan of $500,000 starting May 1. The bank would charge interest at the rate of 1.25 percent per month and require the company to repay interest and principal on May 31. In considering the loan, the bank requested a projected income statement and cash budget for May. The following information...
Brighton, Inc., manufactures kitchen tiles. The company recently expanded, and the controller believes that it will need to borrow cash to continue operations. It began negotiating for a one-month bank loan of $600,000 starting May 1. The bank would charge interest at the rate of 1.25 percent per month and require the company to repay interest and principal on May 31. In considering the loan, the bank requested a projected income statement and cash budget for May. The following information...
Please help with explanation. Thank you in advance. Brighton, Inc., manufactures kitchen tiles. The company recently expanded, and the controller believes that it will need to borrow cash to continue operations. It began negotiating for a one-month bank loan of $500,000 starting May 1. The bank would charge interest at the rate of 1.00 percent per month and require the company to repay interest and principal on May 31. In considering the loan, the bank requested a projected income statement...
Brighton, Inc., manufactures kitchen tiles. The company recently expanded, and the controller believes that it will need to borrow cash to continue operations. It began negotiating for a one-month bank loan of $500,000 starting May 1. The bank would charge interest at the rate of 1.25 percent per month and require the company to repay interest and principal on May 31. In considering the loan, the bank requested a projected income statement and cash budget for May. The following information...
Brighton, Inc., manufactures kitchen tiles. The company recently expanded, and the controller believes that it will need to borrow cash to continue operations. It began negotiating for a one-month bank loan of $600,000 starting May 1. The bank would charge interest at the rate of 1.25 percent per month and require the company to repay interest and principal on May 31. In considering the loan, the bank requested a projected income statement and cash budget for May. The following information is...
Prepare a projected income statement for May. The cost of goods sold should equal the variable manufacturing cost per unit times the number of units sold plus the total fixed manufacturing cost budgeted for the period. When calculating net sales assume cash discounts of 1 percent and bad debt expense of 0.50 percent. (Do not round intermediate calculations.) Brighton, Inc., manufactures kitchen tiles. The company recently expanded, and the controller believes that it will need to borrow cash to continue...