The budget committee of Designer Dresses, an upscale women's clothing retailer, has assembled the following data. As the business manager, you must prepare the budgeted income statements for May and June.
|
a. |
Sales in April were $40,000. You forecast that monthly sales
will increase 10% in May and an additional 22% in June. |
||||||||||||
|
b. |
Designer Dresses maintains inventory of 0$11,000 plus 20% of the sales revenues budgeted for the following month. Monthly purchases average 50% of sales revenue in that same month. Actual inventory on April 30 is $19,800. Sales budgeted for July are $45,000. |
||||||||||||
|
c. |
Monthly salaries amount to $3,000. Sales commissions equal 55% of sales for that month. Combine salaries and commissions into a single figure. | ||||||||||||
|
d. |
Other monthly expenses are as follows:
|
Before completing the budgeted income statements, compute the budgeted cost of goods sold for May and June. (Round your answers to the nearest whole dollar.)
|
May |
June |
||
|
Beginning inventory |
|||
|
Purchases |
|||
|
Cost of goods available for sale |
|||
|
Ending inventory |
|||
|
Cost of goods sold |
Now complete the budgeted income statements for May and June. (Round your answers to the nearest whole dollar.)
|
Designer Dresses |
||||
|
Budgeted Income Statements |
||||
|
For the Months Ended May 31 and June 30 |
||||
|
May |
June |
|||
|
Sales revenue |
||||
|
Cost of goods sold |
||||
|
Gross profit |
||||
|
Operating expenses: |
||||
|
Salaries and commission expense |
||||
|
Rent expense |
||||
|
Depreciation expense |
||||
|
Insurance expense |
||||
|
Operating income |
||||
|
Income tax expense |
||||
|
Net income (loss) |
||||
Answer:
| Calculation of cost of goods sold | ||
| Particulars | may | june |
| Beginning inventory | 19,800 | 21,736 |
| add: purchase (44000*50%),(53680*50%) | 22,000 | 26,840 |
| cost of goods available for sale | 41,800 | 48,576 |
| less: ending inventory(11000+20%*53680), (11000+20%*45,000) | -21,736 | -20,000 |
| Cost of goods sold | 20,064 | 28,576 |
| Budgeted income statement | ||||
| Particulars | may | june | ||
| sale revenue | 44,000 | 53,680 | ||
| cost of goods sold | -20,064 | -28,576 | ||
| gross profit (a) | 23,936 | 25,104 | ||
| operating expenses | ||||
| salaries & commission(3000+sale*55%) | 27,200 | 32,524 | ||
| Rent expenses | 2,600 | 2,600 | ||
| depreciation expenses | 400 | 400 | ||
| insurance expenses | 300 | 300 | ||
| Total operating expenses(b) | 30,500 | 35,824 | ||
| operating income (a)-(b) | -6,564 | -10,720 | ||
| income tax expenses 20% | -1,313 | -2,144 | ||
| net income | -5,251 | -8,576 | ||
The budget committee of Designer Dresses, an upscale women's clothing retailer, has assembled the following data....
Data Table a. Sales in April were $50,000. You forecast that monthly sales will increase 12% in May and an additional 4% in June b. Designer Dresses maintains inventory of $7.000 plus 30% of the sales revenues budgeted for the following month. Monthly purchases average 50% of sales revenue in that same month. Actual inventory on April 30 is $23,800. Sales budgeted for July are $70,000 c. Monthly salaries amount to $3,000. Sales commissions equal 10% of sales for that...
The budget committee of printer office supply has assembled the
following data:
Question 2: The budget committee of Printer Office Supply has assembled the following data: Printer Office Supply Balance Sheet March 31, 2014 Liabilities Current Assets Cash Accounts Receivable Merchandise Inventory Current Liabilities: Accounts Payable S 34,000 15,000 19,500 1,400 16.250 4,725 Salaries and Commissions Payable Total Liabilities $ 20,975 $ 69,900 Stockholders' Equity Prepaid Insurance Total Current Assets Property, Plant, and Equipment: Equipment and Fixtures Common Stock 17,000...
Problem 22-05A (Part Level Submission) The budget committee of Suppar Company collects the following data for its San Miguel Store in preparing budgeted income statements for May and June 2020. 1. Sales for May are expected to be $800,000. Sales in June and July are expected to be 5% higher than the preceding month. 2. Cost of goods sold is expected to be 75% of sales. 3. Company policy is to maintain ending merchandise inventory at 10% of the following...
Problem 22-05A (Part Level Submission) The budget committee of Suppar Company collects the following data for its San Miguel Store in preparing budgeted income statements for May and June 2020. 1. Sales for May are expected to be $800,000. Sales in June and July are expected to be 5% higher than the preceding month. 2. Cost of goods sold is expected to be 75% of sales. 3. Company policy is to maintain ending merchandise inventory at 10% of the following...
system Announcements CALCULATOR PRINTER VERSION BAC Problem 9-5A (Part Level Submission) (Video) The budget committee of Suppar Company collects the following data for its San Miguel Store in preparing budgeted income statements for May and June 2020. 1. Sales for May are expected to be $1,200,000. Sales in June and July are expected to be 5% higher than the preceding month. 2. Cost of goods sold is expected to be 75% of sales. 3. Company policy is to maintain ending...
CALCULATOR PRINTER VERSION Problem 9-5A (Part Level Submission) (Video) The budget committee of Suppar Company collects the following data for its San Miguel Store in preparing budgeted income statements for May and June 2020 1. Sales for May are expected to be $1,200,000. Sales in June and July are expected to be 5% higher than the preceding month. 2. Cost of goods sold is expected to be 75% of sales. 3. Company policy is to maintain ending merchandise inventory at...
Citrus Girl Company (CGC) purchases quality citrus produce from local growers and sells the produce via the Intemet across the United States. To keep costs down, CGC maintains a warehouse, but no showroom or retail sales outlets. CGC has the following information for the second quarter of the year 1. Expected monthly sales for April, May, June, and July are $140,000, $110,000, $230,000, and $50,000, respectively 2. Cost of goods sold is 15 percent of expected sales. 3. CGC's desired...
Citrus Girl Company (CGC) purchases quality citrus produce from local growers and sells the produce via the Internet across the United States. To keep costs down, CGC maintains a warehouse, but no showroom or retail sales outlets. CGC has the following information for the second quarter of the year: 1. Expected monthly sales for April, May, June, and July are $240,000, $210,000, $330,000, and $110,000, respectively. 2. Cost of goods sold is 40 percent of expected sales. 3. CGC's desired...
Citrus Girl Company (CGC) purchases quality citrus produce from local growers and sells the produce via the Internet across the United States. To keep costs down, CGC maintains a warehouse, but no showroom or retail sales outlets. CGC has the following information for the second quarter of the year: 1. Expected monthly sales for April, May, June, and July are $190,000, $160,000, $280,000, and $60,000, respectively. 2. Cost of goods sold is 40 percent of expected sales. 3. CGC's desired...
Citrus Girl Company (CGC) purchases quality citrus produce from
local growers and sells the produce via the Internet across the
United States. To keep costs down, CGC maintains a warehouse, but
no showroom or retail sales outlets. CGC has the following
information for the second quarter of the year:
1. Expected monthly sales for April, May, June, and July are $320,000, $290,000, $410,000, and $190,000, respectively. 2. Cost of goods sold is 50 percent of expected sales. 3. CGC's desired...