Question

In: Accounting

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 is available:

Cash Balance, May 31, 2017 $11,000
Cash collections from customers in June 43,000
Cash paid for land in June 10,000
Patent amortization expense in June 5,000
Cash paid for merchandise in June 20,000
Cash paid for operating expenses in June 20,000
Cash dividend paid in June 5,000

The minimum cash balance desired is $5,000. What is the deficiency of cash before financing at June 30, 2017?
A) $(5,000)
B) $(6,000)               
C) $(11,000)
D) $(12,000)

Solutions

Expert Solution

  • All working forms part of the answer
  • Question 35

A

February Sales

$           75,000.00

B = A x 3%

Other expenses

$             2,250.00

C

Wages

$           20,000.00

D

Advertising

$           10,000.00

E

Depreciation

$             5,000.00

F = B+C+D+E

Total Operating Expenses for February

$           37,250.00

Correct Answer = Option ‘C’ $ 37,250

  • Question 37

Beginning Cash balance

$       11,000.00

Cash collected

$       43,000.00

Cash available

$        54,000.00

Less: Cash payments:

   For Land

$       10,000.00

   For merchandise

$       20,000.00

   For operating expenses

$      20,000.00

   For Dividends

$          5,000.00

Total Payments

$       55,000.00

Minimum balance required

$          5,000.00

Total

$        60,000.00

Deficiency of Cash

$        (6,000.00)

Correct Answer = Option ‘B’ $ (6,000)


Related Solutions

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
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...
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...
+++ Show excel formulas please +++ Marvel Company has the following budgeted sales for the selected...
+++ Show excel formulas please +++ Marvel Company has the following budgeted sales for the selected four-month period: Month                                  Unit Sales October                                40,000 November                          70,000 December                           50,000 January                                 60,000 There were 14,000 units of finished goods in inventory at the beginning of October. Plans are to have an inventory of finished product equal to 25 percent of the unit sales for the next month. Five pounds of a single raw material are required for each...
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...
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...
The following credit sales are budgeted by Blossom Company. January 200600 February 295000 March 413000 The...
The following credit sales are budgeted by Blossom Company. January 200600 February 295000 March 413000 The company’s past experience indicates that 60% of the accounts receivable are collected in the month of sale, 40% in the month following the sale. The anticipated cash inflow for the month of March is $247800. $365800. $413000. $401200.
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?
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....
Please Show Work. Thank you! __________________________________________________________________________ Question 3 Big Three Company produces televisions. Budgeted sales for...
Please Show Work. Thank you! __________________________________________________________________________ Question 3 Big Three Company produces televisions. Budgeted sales for February are 1,090 units. Finished goods inventory on February 1 is budgeted to be 310 units, and Finished goods inventory on February 28 is budgeted to be 135 units. What is the budgeted production for February? __________________________________________________________________________ Question 4 Pope Company produces a model fan, which currently has a net loss. Below are its sales and costs Sales revenue $135,130 Less: Variable costs 41,851...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT