schedule containing inventory budgets by month for production in unit for April, May and June
1. Production Budget (in units) | |||
Particulars | April | May | Jun |
Budgeted Sales | 600,000.00 | 500,000.00 | 600,000.00 |
Add: Closing Stocks | 125,000.00 | 150,000.00 | 150,000.00 |
Less: Opening Stock | 150,000.00 | 125,000.00 | 125,000.00 |
Production Units | 575,000.00 | 525,000.00 | 625,000.00 |
2. schedule containing inventory budgets by month for row material in pounds for April, May
2. Raw Material Purchase Budget In Pounds | ||
Particulars | April | May |
production Units | 575,000.00 | 525,000.00 |
Add: Closing Stocks | 210,000.00 | 250,000.00 |
Less: Opening Stock | 150,000.00 | 210,000.00 |
purchase row material | 635,000.00 | 565,000.00 |
Amount @.25 pound | 158,750.00 | 141,250.00 |
3. income statement for the month of May
3 Income Statement for the Month of May | ||
Particulars | details | Amount |
Sales | 500000*4 | 2000000 |
less- discount | 200000*1% | 20000 |
bad debts | 2000000*0.50% | 10000 |
Net sales | 1970000 | |
cost of sales | ||
variable cost | 1090000 | |
fixed cost | 390000 | |
Balance | 490000 | |
expenses | ||
selling expenses | 2000000*10% | 200000 |
administration cost( including depreciation) | 160000 | |
interest expenses | 500000*1% | 50000 |
operating profit | 80000 |
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 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 $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 $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 $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...