Question
Can you help me in part 2 Please.
Oxford, Inc., is preparing its master budget for the quarter ended June 30. It sells a single product for $40 each. Sales are
Part 2: Demand for your product is much larger than expected. The amount of product sold for the quarter is acutally 50% over
0 0
Add a comment Improve this question Transcribed image text
Answer #1

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
Add a comment
Know the answer?
Add Answer to:
Can you help me in part 2 Please. Oxford, Inc., is preparing its master budget for the quarter ended June 30. It se...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and...

    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

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT