Cash Budget Problem: Mia Company
Prepare Cash Budget for April, May, June
2018
Follow the following...
Cash Budget Problem: Mia Company
Prepare Cash Budget for April, May, June
2018
Follow the following to prepare the budget:
1. Real Sales
2018:
January
- $100,000
February
- $200,000
March
- $150,000
Projected for 2018: April
- $400,000
May
- $300,000
June
- $200,000
Sales Payment
History:
10% cash
40% Accts. Rec. – collected n/30 days
50% Accts. Rec. – collected n/60...
Nieto Company’s budgeted sales and direct materials purchases
are as follows.
Budgeted Sales
Budgeted D.M. Purchases...
Nieto Company’s budgeted sales and direct materials purchases
are as follows.
Budgeted Sales
Budgeted D.M. Purchases
January
$254,600
$39,100
February
220,900
46,100
March
326,000
48,500
Nieto’s sales are 30% cash and 70% credit. Credit sales are
collected 10% in the month of sale, 50% in the month following
sale, and 36% in the second month following sale; 4% are
uncollectible. Nieto’s purchases are 50% cash and 50% on account.
Purchases on account are paid 40% in the month of purchase,...
The PM Company has planned the following sales for the next
three months:
January
February
March...
The PM Company has planned the following sales for the next
three months:
January
February
March
Budgeted Sales
$40,000
$50,000
$70,000
Sales are made 20% for cash and 80% on account (A/R). From
experience, the company has learned that a month's sales on account
are collected according to the following pattern:
Month of sale:
60%
First month following sale:
30%
Second month following sale:
8%
Uncollectible:
2%
The following additional information has been provided for
March:
Inventory purchases (70% paid...
Nieto Company’s budgeted sales and direct materials purchases
are as follows.
Budgeted Sales
Budgeted D.M. Purchases...
Nieto Company’s budgeted sales and direct materials purchases
are as follows.
Budgeted Sales
Budgeted D.M. Purchases
January
$215,000
$33,800
February
253,000
44,500
March
262,000
39,200
Nieto’s sales are 30% cash and 70% credit. Credit sales are
collected 10% in the month of sale, 50% in the month following
sale, and 36% in the second month following sale; 4% are
uncollectible. Nieto’s purchases are 50% cash and 50% on account.
Purchases on account are paid 40% in the month of purchase,...
Nieto Company’s budgeted sales and direct materials purchases
are as follows.
Budgeted Sales
Budgeted D.M. Purchases...
Nieto Company’s budgeted sales and direct materials purchases
are as follows.
Budgeted Sales
Budgeted D.M. Purchases
January
$237,300
$33,500
February
230,100
38,900
March
329,800
38,300
Nieto’s sales are 30% cash and 70% credit. Credit sales are
collected 10% in the month of sale, 50% in the month following
sale, and 36% in the second month following sale; 4% are
uncollectible. Nieto’s purchases are 50% cash and 50% on account.
Purchases on account are paid 40% in the month of purchase,...
Kline Sisters Company operates a gift shop where peak sales and
activity occur in the months...
Kline Sisters Company operates a gift shop where peak sales and
activity occur in the months of December and January. Data
regarding the store's operations follow:
Sales are budgeted at $360,000 for January, 320,000 for
February, and $250,000 for March and $240,000 in April.
Collections are expected to be 30% in the month of sale, 65% in
the month following the sale, 3% in the second month following sale
and 2% uncollectible.
The cost of goods sold is 76% of...
Deacon Company is a merchandising company that is preparing a
budget for the three-month period ended...
Deacon Company is a merchandising company that is preparing a
budget for the three-month period ended June 30th. The following
information is available
Deacon Company
Balance Sheet
March 31
Assets
Cash
$
60,000
Accounts receivable
30,000
Inventory
43,900
Buildings and equipment, net of depreciation
131,000
Total assets
$
264,900
Liabilities and Stockholders’
Equity
Accounts payable
$
72,000
Common stock
70,000
Retained earnings
122,900
Total liabilities and stockholders’ equity
$
264,900
Budgeted Income Statements
April
May
June
Sales
$
113,000
$...
Deacon Company is a merchandising company that is preparing a
budget for the three-month period ended...
Deacon Company is a merchandising company that is preparing a
budget for the three-month period ended June 30th. The following
information is available
Deacon Company
Balance Sheet
March 31
Assets
Cash
$
55,000
Accounts receivable
36,000
Inventory
40,000
Buildings and equipment, net of depreciation
100,000
Total assets
$
231,000
Liabilities and Stockholders’
Equity
Accounts payable
$
51,300
Common stock
70,000
Retained earnings
109,700
Total liabilities and stockholders’ equity
$
231,000
Budgeted Income Statements
April
May
June
Sales
$
100,000
$...
Depotissimo " , has predicted the following sales for the first
four months of 2015
January...
Depotissimo " , has predicted the following sales for the first
four months of 2015
January
$ 7,000
March
$ 15,000
February
$ 12,000
April
$ 18,000
Monthly purchases of raw materials accounts for 50 % of sales
forecast for the next month.
Of total raw material purchases , payments are 50% in cash in
the same month and 50% on credit. Of credit purchases 70% is paid
in the following month and 30% is paid in two months.
Predicted...
Month
Budgeted Cash Sales
Budgeted Credit Sales
Budgeted Cash Purchases
Budgeted Credit Purchases
December
8,000
21,000...
Month
Budgeted Cash Sales
Budgeted Credit Sales
Budgeted Cash Purchases
Budgeted Credit Purchases
December
8,000
21,000
January
9,000
23,000
February
11,000
25,000
March
77,800
12,000
12,000
22,000
March
68,500
12,500
12,500
23,500
May
72,000
12,300
12,300
24,500
Wages & other operating expenses are estimated as
follows:
Month
Wages
Other Expenses
March
20,000
28,000
April
17,500
22,000
May
20,000
23,000
Newequipment purchased in February for $16,750 istobepaid
forin April.
New furniture purchased in March for $15,000 isto be paid...