a)
Sales Budget | |||||
S.No | Particulars | April | May | June | July |
A | Budgeted Sales during the Month | 800 | 1000 | 600 | 1200 |
B | Selling Price Per Unit | $40 | $40 | $40 | $40 |
C | Budgeted Sales in $ ( A*B ) | $32,000 | $40,000 | $24,000 | $48,000 |
b)
Cash Collection Budget | |||||
S.No | Particulars | April | May | June | July |
A | Total Budgeted Sales during the Month | $32,000 | $40,000 | $24,000 | $48,000 |
B | Cash Sales during the Month( A*60%) | $19,200 | $24,000 | $14,400 | $28,800 |
C | Credit Sales of Previous Month Collected(Note-1)(40%) | $12,000 | $12,800 | $16,000 | $9,600 |
D | Toatl Cash Collections | $31,200 | $36,800 | $30,400 | $38,400 |
c)
Merchandise Purchase Budget | ||||
S.No | Particulars | April | May | June |
A | Budgeted Sales in Units during the Month | 800 | 1000 | 600 |
B | Raw Material Requied for each unit (Assumption) | 1 | 1 | 1 |
C | Raw Material Required for Budgeted Sales (A*B ) | 800 | 1000 | 600 |
D | Opening Stock of Raw material | 480 | 600 | 360 |
E | Budgeted Sales Units of Following Month | 1000 | 600 | 1200 |
G | Raw Material Required for Budgeted Sales of Following Month | 1000 | 600 | 1200 |
H | Closing Stock to be maintained ( G*60%) | 600 | 360 | 720 |
I |
Material to be Purchased during the Month (C-D+H)(Pounds) |
920 | 760 | 960 |
J | Material Perice Per Unit | $20 | $20 | $20 |
K |
Material to be Purchased during the Month (I*J)(Value) |
$18,400 | $15,200 | $19,200 |
d)
Schedule for Cash Disbursement for Purchases of Merchandise | ||||
S.No | Particulars | April | May | June |
A | Material to be Purchased during the Month | 920 | 760 | 960 |
B | Material Perice Per Unit | $20 | $20 | $20 |
C |
Material to be Purchased during the Month (A*B)(Value) |
$18,400 | $15,200 | $19,200 |
D | Cash Purchases ( C*50% ) | $9,200 | $7,600 | $9,600 |
E | Credit Purchase of previous month paid in Current Month | $11,000 | $9,200 | $7,600 |
F | Total Cash Payments for Direct Materials during the Month | $20,200 | $16,800 | $17,200 |
e)
Schedule for Cash Disbursement for Selling and Adminstrative Expenses | ||||
S.No | Particulars | April | May | June |
A | Total Budgeted Sales during the Month | $11,000 | $9,200 | $7,600 |
B | Sales Commission (A*10%) | $1,100 | $920 | $760 |
C | Shipping (A*3%) | $330 | $276 | $228 |
D | Office Salaries ($3000 Per Month) | $3,000 | $3,000 | $3,000 |
E | Rent ($5000 Per Month) | $5,000 | $5,000 | $5,000 |
F | Total Cash Payments for Selling and Admin Expenses during the Month | $9,430 | $9,196 | $8,988 |
f)
Combined Cash Budget | ||||
S.No | Particulars | April | May | June |
A | Opening Cash | $12,000 | $12,000 | $22,350 |
B | Toatl Cash Collections | $31,200 | $36,800 | $30,400 |
C | Cash Payments: | |||
D | Total Cash Payments for Direct Materials during the Month | $20,200 | $16,800 | $17,200 |
E | Total Cash Payments for Selling and Admin Expenses during the Month | $9,430 | $9,196 | $8,988 |
G | Opening Loan Balance | $2,000 | $450 | $0 |
H | Interest Payment( 1% Per Month) | $20 | $5 | $0 |
I | Total Cash Payments (D+E+F+G+H) | $29,650 | $26,001 | $26,188 |
J | Cash Balance (A+B-I) | $13,550 | $22,800 | $26,562 |
K | Minimum Cash Balance to be Maintained | $12,000 | $12,000 | $12,000 |
L | Loan to be taken (If I < J,J-I) | $0 | $0 | $0 |
N | Loan Repaymnet | $1,550 | $450 | $0 |
O | Closing Balance (J+L-N) | $12,000 | $22,350 | $26,562 |
Can you help me in part 2 Please. Oxford, Inc., is preparing its master budget for the quarter ended June 30. It se...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and cash payments for merchandise for the next three months follow: Budgeted April May June Sales $ 30,900 $ 41,100 $ 25,100 Cash payments for merchandise 22,400 15,700 16,100 Sales are 70% cash and 30% on credit. All credit sales are collected in the month following the sale. The March 31 balance sheet includes balances of $13,100 in cash, $13,100 in accounts receivable, $11,000 in...
Built-Tight is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for product costs for the quarter follow. Sales are 20% cash and 80% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $15,000 in cash; $44,400 in accounts receivable; $3,900 in accounts payable; and a $4,400 balance in loans payable. A minimum cash balance of $15,000 is required. Loans are obtained at...
Required: Prepare a master budget for the three-month period ending June 30. Include the following detailed schedules: 1. a. A sales budget, by month and in total. b. A schedule of expected cash collections, by month and in total. c. A merchandise purchases budget in units and in dollars. Show the budget by month and in total. d. A schedule of expected cash disbursements for merchandise purchases, by month and in total. 2. A cash budget. Show the budget by...
Built-Tight is preparing its master budget for the quarter ended
September 30. Budgeted sales and cash payments for product costs
for the quarter follow.
July
August
September
Budgeted sales
$
58,000
$
74,000
$
54,000
Budgeted cash payments for
Direct materials
15,960
13,240
13,560
Direct labor
3,840
3,160
3,240
Factory overhead
20,000
16,600
17,000
Sales are 25% cash and 75% on credit. All credit sales are
collected in the month following the sale. The June 30 balance
sheet includes balances...
Kelsey is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for merchandise for the next three months follow. Budgeted July 562,450 43.600 August $81,500 32.009 September $49,609 3 2.30 Cash payments for nerchandise Sales are 20% cash and 80% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet Includes balances of $13.900 in cash, $51,100 in accounts receivable; $6,100 in accounts payable, and a...
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 $ 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...
Dalley Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalley Manufacturing's operations: (Click the icon to view the data.) (Click the icon to view additional data.) Read the requirements. Requirement 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total. Dalley Manufacturing Cash Collections Budget For the Quarter Ended March 31 Month January February March Quarter Cash sales Credits sales Total...
Please prepare the master budget, but please use
template i provided. The template is the last 3 pages i attached
and the steps are numbered.The first page is the actual question.
Thank you
...) Oxford, Inc., is preparing its master budget for the quarter ended June 30. It sells a single product for $40 each. Sales are 60% cash and 40% on credit. All credit sales are collected in the month following the sale. At March 31. the balance in...