Please help with explanation. Thank you in advance.
Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you. | ||||
Part a1 | ||||
April | May | June | ||
Budgeted sales—Units | 550,000 | 450,000 | 550,000 | |
Inventory required at end of month | 90,000 | 110,000 | 110,000 | |
Total to be accounted for | 640,000 | 560,000 | 660,000 | |
Less inventory on hand at beginning of month | (110,000) | (90,000) | (110,000) | |
Budgeted production—Units | 530,000 | 470,000 | 550,000 | |
Part a2 | ||||
April | May | June | ||
Budgeted production—Pounds (1/4 lb. per Unit) | 132,500 | 117,500 | 137,500 | |
Inventory required at end of month | 47,000 | 55,000 | ||
Total to be accounted for | 179,500 | 172,500 | ||
Less inventory on hand at beginning of month | (57,000) | (53,500) | ||
Balance required by purchase | 122,500 | 119,000 | ||
Budgeted purchases—Pounds | ||||
(Based on Minimum Shipments of 64,500 lbs. each) | 129,000 | 64,500 | ||
Part b | ||||
Sales (450,000 Units at $4) | $ 1,800,000 | |||
Less: Cash discounts on Sales | $ 18,000 | |||
Estimated bad debts (1/2 percent of gross sales) | $ 9,000 | $ (27,000) | ||
Net Sales | $ 1,773,000 | |||
Cost of Sales: | ||||
Variable cost per unit | $1,100,000/500,000*450,000 | $ 990,000 | ||
Fixed Cost | $ 410,000 | $ (1,400,000) | ||
Gross profit on sales | $ 373,000 | |||
Expenses: | ||||
Selling (10 percent of gross sales) | $ 180,000 | |||
Administrative ($165,000 per month) | $ 155,000 | |||
Interest expense (.01 x $500,000) | $ 5,000 | $ (340,000) | ||
Operating profit | $ 33,000 |
Please help with explanation. Thank you in advance. Brighton, Inc., manufactures kitchen tiles. The company recently...
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 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.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 $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 $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 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 $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...
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...
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...
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...