Question

In: Accounting

Funnel Manufacturing Company has provided the follwoing information: Month Budgeted Sales January $ 76,000 February 85,000...

Funnel Manufacturing Company has provided the follwoing information:

Month

Budgeted
Sales

January

$ 76,000

February

85,000

March

92,000

April

79,000

Budgeted Selling and Administrative Expenses Per Month are as follows:

Wages, $15,000

Advertising, $12,000

Depreciation, $3,000

Other, 4 percent of Sales

Cost of Goods Sold is 60% of Sales. All inventory is purchased in the month it is sold. Inventory purchases are paid 2/3 in the month of purchase, the remaining 1/3 paid in the following month.  

The budgeted net income for February would be:

a.

$600

b.

$7,000

c.

$5,300

d.

$3,600

How much cash will be paid for purchases during the month of February?

a.

$49,200

b.

$45,600

c.

$96,600

d.

$51,000

What amount of Accounts Payable would be reported on the Balance Sheet at the end of February?

a.

$28,333

b.

$34,000

c.

$17,000

d.

$54,000

Solutions

Expert Solution

1)
The budgeted net income for February would be:
a.$600
Working:
February
# 1 Budgeted Sales $       85,000
Cost of goods sold           51,000
Gross Profit           34,000
Selling and Administrative Expenss:
Wages        15,000
Advertising        12,000
Depreciation           3,000
Other           3,400           33,400
Net Income                 600
# 2 Other Expense = Budgeted Sales *4%
= $       85,000 *4%
= $         3,400
2)
Cash will be paid for purchases during the month of February:
a. $49,200
Working:
January February
Budgeted Sales        76,000        85,000
Cost of goods sold        45,600        51,000
February
Purchase of last month        45,600 x 1/3        15,200
Purchase of current month        51,000 x 2/3        34,000
Cash will paid for the purchase        49,200
3)
c.$17,000
Working:
February
Purchase of current month payable at the end of Month
       51,000 x 1/3        17,000

Related Solutions

Please show work 35. Highland Company has the following information: Month Budgeted Sales January $70,000 February...
Please show work 35. Highland Company has the following information: Month Budgeted Sales January $70,000 February 75,000 March 82,000 April 89,000 Budgeted Operating Expenses Per Month Wages $20,000 Advertising 10,000 Depreciation 5,000 Other expenses 3% of sales All cash expenses are paid as incurred. What are the total operating expenses budgeted for the month of February? A) $30,000 B) $35,040 C) $37,250 D) $38,200 37. Saltine Company is preparing a cash budget for the month of June. The following information...
La Famiglia Pizzeria provided the following information for the month of October: a. Sales are budgeted...
La Famiglia Pizzeria provided the following information for the month of October: a. Sales are budgeted to be $157,000. About 85% of sales is cash; the remainder is on account. b. La Famiglia expects that, on average, 70% of credit sales will be paid in the month of sale, and 28% will be paid in the following month. c. Food and supplies purchases, all on account, are expected to be $116,000. La Famiglia pays 25% in the month of purchase...
Radcliff Ltd. has budgeted the following sales for the next three months: January February March Budgeted...
Radcliff Ltd. has budgeted the following sales for the next three months: January February March Budgeted Sales $80,000 $100,000 $140,000 Ninety percent of sales are on account and ten percent of sales are cash sales. A month's sales on account are collected as follows: Month of sale 50% First month following sale 40% Second month following sale 9% Uncollectible 1% The company requires a minimum cash balance of $7,000 to start a month. The beginning cash balance in March is...
A company budgeted unit sales of 154000 units for January, 2017 and 150000 units for February...
A company budgeted unit sales of 154000 units for January, 2017 and 150000 units for February 2017. The company has a policy of having an inventory of units on hand at the end of each month equal to 30% of next month's budgeted unit sales. If there were 46200 units of inventory on hand on December 31, 2016, how many units should be produced in January, 2017 in order for the company to meet its goals?
The following credit sales are budgeted by Roswell Company: $30,000 in January,$50,000 in February and $70,000...
The following credit sales are budgeted by Roswell Company: $30,000 in January,$50,000 in February and $70,000 in March. The company's past experience indicates that 70% of the credit sales are collected in the month of sale and 30% in the month following the sale. The anticipated cash inflow for the month of March is Select one: a. $58,800 b. $44,000 c. $70,000 d. $64,000
Wyatt Company has budgeted the following units sales for 2011: January 10,000 units February 8,000 units...
Wyatt Company has budgeted the following units sales for 2011: January 10,000 units February 8,000 units March 9,000 units April 11,000 units May 15,000 units Data regarding Finished Goods and Raw Materials Inventory is as follows: FINISHED GOODS: The finished goods units on hand on December 31, 2010 was 2,000 units. Each unit required 2 pounds of raw materials that are estimated to cost an average of $4 per pound. It is the company's policy to maintain a finished goods...
Contigo Company provided the following information related to its inventory sales. Actual – December: 80,000 Budgeted-January:...
Contigo Company provided the following information related to its inventory sales. Actual – December: 80,000 Budgeted-January: 140,000 Budgeted-February: 180,000 Budgeted-March: 120,000 Contigo desired ending inventory levels are 20% of the following months projected COGS. Budgeted purchases of inventory in February 2017 would have been:
Eunice Ltd. has the following budgeted sales for the next six-month period: Month Unit Sales January...
Eunice Ltd. has the following budgeted sales for the next six-month period: Month Unit Sales January 80,000 February 90,000 March 120,000 April 150,000 May 180,000 June 120,000 Eunice Ltd. sells a single product at a price of $60 per unit. There were 18,000 units of finished goods in inventory at the beginning of February. Eunice Ltd.’s policy is to keep the inventory of finished goods equal to 20% of the unit sales for the next month. Three kilograms of materials...
7. A.    Below is budgeted production and sales information for Flushing Company for the month...
7. A.    Below is budgeted production and sales information for Flushing Company for the month of December: Product XXX Product ZZZ Estimated beginning inventory 29,200 units 18,100 units Desired ending inventory 35,600 units 14,100 units Region I, anticipated sales 341,000 units 262,000 units Region II, anticipated sales 188,000 units 143,000 units The unit selling price for product XXX is $4 and for product ZZZ is $15. Budgeted sales for the month are a. $9,555,000 b. $14,010,000 c. $3,736,000 d....
limerick, Inc: has budgeted total sales for January, February, and March of $800,000, $900,000, and $950,000...
limerick, Inc: has budgeted total sales for January, February, and March of $800,000, $900,000, and $950,000 respectively. Cash sales are normally 25% of total sales. Of the credit sales, 40% are collected in the same month as the sale, and 60% are collected during the first month after the sale. Compute the amount of cash received from sales during the month of February.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT