Scenario-A
Closing Inventory | 50% | Dec Sales- | 80000 | April Sales- | 10000 | ||
1 | Sales Budget | ||||||
January | February | March | Total | ||||
No. of units | 60000 | 30000 | 60000 | 150000 | |||
S.P per unit | 50 | 50 | 50 | 50 | |||
Total Sales | 3000000 | 1500000 | 3000000 | 7500000 | |||
2 | Purchase Budget | ||||||
January | February | March | Total | Dec | |||
Current Sales | 60000 | 30000 | 60000 | 150000 | 80000 | ||
Closing Inventory | 15000 | 30000 | 5000 | 50000 | 30000 | ||
-Opening Inventory | -30000 | -15000 | -30000 | -75000 | -40000 | ||
Purchase | 45000 | 45000 | 35000 | 125000 | 70000 | ||
Cost per unit | 35 | 35 | 35 | 35 | 35 | ||
Total Purchase | 1575000 | 1575000 | 1225000 | 4375000 | 2450000 | ||
3 | Cash Budget | ||||||
January | February | March | Total | ||||
Sales Collection: | |||||||
40% in same month | 1200000 | 600000 | 1200000 | 3000000 | |||
60% in next month | 2400000 | 1800000 | 900000 | 5100000 | |||
Selling Cost | -720000 | -360000 | -720000 | -1800000 | |||
Rent | -35000 | -35000 | -35000 | -105000 | |||
Advertising | -44000 | -44000 | -44000 | -132000 | |||
Purchase paid in next month | -2450000 | -1575000 | -1575000 | -5600000 | |||
Total CashFlow (a) | 351000 | 386000 | -274000 | 463000 | |||
Opening Cash balance (b) | 70000 | 70000 | 70000 | 70000 | |||
Minimum Cash requirement (c ) | 70000 | 70000 | 70000 | 210000 | |||
Excess/(Deficit) (d=a+b-c) | 351000 | 386000 | -274000 | 463000 | |||
Borrowing/(Repayment) (e=-d) | -351000 | -386000 | 274000 | -463000 | |||
Ending Cash Balance (f=a+b+e) | 70000 | 70000 | 70000 | 70000 | |||
4 | Budgeted Income Statement | ||||||
January | February | March | Total | ||||
Sales | 3000000 | 1500000 | 3000000 | 7500000 | |||
Closing Stock | 525000 | 1050000 | 175000 | 1750000 | |||
Less: | |||||||
Opening Stock | -1050000 | -525000 | -1050000 | -2625000 | |||
Purchase | -1575000 | -1575000 | -1225000 | -4375000 | |||
Selling Cost | -720000 | -360000 | -720000 | -1800000 | |||
Rent | -35000 | -35000 | -35000 | -105000 | |||
Advertising | -44000 | -44000 | -44000 | -132000 | |||
Depreciation | -66000 | -66000 | -66000 | -198000 | |||
Interest on Borrowing | 0 | 0 | 2740 | 2740 | |||
Net Profit/ (Loss) | 35000 | -55000 | 37740 | 17740 |
(Remaining answer written in comments due to limitation of letters in answer section.)
(Kindly Rate Positively, if found helpful.)
339 AF211 Budget Project Hepare the following hodes for a retail company on a computer spread computer spreadsheet...
Purchases Budget in Units and Dollars Budgeted sales of Wirtz Music Shop for the first six months of 2017 are as follows: Month Unit Sales Month Unit Sales January 155,000 April 240,000 February 185,000 May 205,000 March 225,000 June 265,000 Beginning inventory for 2017 is 35,000 units. The budgeted inventory at the end of a month is 40 percent of units to be sold the following month. Purchase price per unit is $5. Prepare a purchases budget in units and...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the first quarter: a. As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances: Debits Credits Cash $ 50,000 Accounts receivable 232,000 Inventory 57,000 Buildings and equipment (net) 367,000 Accounts payable $ 93,000 Capital shares 510,000 Retained earnings 103,000 $ 706,000...
ACCT 116 Budget Assignment 2017F 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...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the first quarter: a. As of December 31 (the end of the prior quarter), the company's general ledger showed the following account balances: Credits Cash Accounts receivable Inventory Buildings and equipment (net) Accounts payable Capital shares Retained earnings Debits $ 49,000 224,000 57,000 356,000 $ 93,000 485,000 108,000 $686,000 $686,000...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the first quarter: a. As of December 31 (the end of the prior quarter), the company's general ledger showed the following account balances: Credits Cash Accounts receivable Inventory Buildings and equipment (net) Accounts payable Capital shares Retained earnings Debits $ 48,000 232,000 61,500 375,000 $ 93,000 520,000 103,500 $716,500 $716,500...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the first quarter: a. As of December 31 (the end of the prior quarter), the company's general ledger showed the following account balances: Credits Cash Accounts receivable Inventory Buildings and equipment (net) Accounts payable Capital shares Retained earnings Debits $ 50,000 224,000 61,500 366,000 $ 91,000 505,000 105,500 $701,500 $701,500...
Hillyard Company, an office supplies specialty store, prepares
its master budget on a quarterly basis. The following data have
been assembled to assist in preparation of the master budget for
the first quarter:
a.
As of December 31 (the end of the prior quarter), the company’s
general ledger showed the following account balances:
Debits
Credits
Cash
$
46,000
Accounts receivable
232,000
Inventory
57,000
Buildings and equipment (net)
375,000
Accounts payable
$
96,000
Capital shares
505,000
Retained earnings
109,000
$
710,000...
A company sells cars. The data following data are taken from a statement of financial position at March 31, 2019 Cash $6000 Accounts Receivable $18000 Inventories $34000 Accounts payable $19750 Additional info: 1) Actual and expected sales are: March (Actual) $40000 April $50000 May $62000 June $80000 2) 30% of sales are on credit, the remaining are in cash. All credit sales are collected in the following month. 3) The ending inventory should be 70% of the following month's sales...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the first quarter: a. As of December 31 (the end of the prior quarter), the company's general ledger showed the following account balances: Credits Cash Accounts receivable Inventory Buildings and equipment (net) Accounts payable Capital shares Retained earnings Debits $ 49,000 224,000 60,000 376,000 $ 93,000 510,000 106,000 $709,000 $709,000...
4. Cash Budget (20 points) The following information pertains to Monroe Company: Month December January February March Sales $130,000 $68,000 $87,000 $106,000 Purchases $65,000 $35,000 $46,000 $48,000 • Cash is collected from customers in the following manner: o Month of sale 30% o Month following the sale 65% o Written off as uncollectible 5% 45% of purchases are paid for in cash in the month of purchase, and the balance is paid the following month. Labor costs are 20% of...
> How can I access the comments section so I can compare to the rest of my work?
Sonson Thu, Nov 25, 2021 8:27 AM