Question
Wildhorse Company prepares monthly cash budgets. Relevant data from operating budgets for 2022 are as follows. January February Sales $439,200 $488,000 Direct materials purchases 146,400
Wildhorse Company prepares monthly cash budgets. Relevant data from operating budgets for 2022 are as follows.
January | February | |||
---|---|---|---|---|
Sales | $439,200 | $488,000 | ||
Direct materials purchases | 146,400 | 152,500 | ||
Direct labor | 109,800 | 122,000 | ||
Manufacturing overhead | 85,400 | 91,500 | ||
Selling and administrative expenses | 96,380 | 103,700 |
All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct materials purchases are paid in cash in the month of purchase, and the balance due is paid in the month following the purchase. All other items above are paid in the month incurred except for selling and administrative expenses that include $1,220 of depreciation per month. Other data:
1. | Credit sales: November 2021, $305,000; December 2021, $390,400. | |
2. | Purchases of direct materials: December 2021, $122,000. | |
3. | Other receipts: JanuaryCollection of December 31, 2021, notes receivable $18,300; FebruaryProceeds from sale of securities $7,320. | |
4. | Other disbursements: FebruaryPayment of $7,320 cash dividend. |
Is this the correct answer I only have 1 more try for this question? The companys cash balance on January 1, 2022, is expected to be $73,200. The company wants to maintain a minimum cash balance of $61,000.
Cash Budget choose the accounting period For the Two Months Ending February 28, 2022 January February select an opening cash budget item Beginning Cash Balance $enter a dollar amount 73200 $enter a dollar amount 62,220 select between addition and deduction Add : select an opening name for section one Receipts select a cash budget item Collections from Customers enter a dollar amount 397,720 enter a dollar amount 453,840 select a cash budget item Notes Receivable enter a dollar amount 18,300 enter a dollar amount 0 select a cash budget item Sale of Securities enter a dollar amount 0 enter a dollar amount 7,320 select a closing name for section one Total Receipts enter a total amount for section one 416,020. enter a total amount for section one 453,840 select a summarizing line for the first part Total Available Cash enter a total amount for the first part 489,220. enter a total amount for the first part 523,380. select between addition and deduction Less : select an opening name for section two Disbursements select a cash budget item Direct Materials enter a dollar amount 136,640. enter a dollar amount 150,060 select a cash budget item Direct Labor enter a dollar amount 109,800 enter a dollar amount 122,000 select a cash budget item Manufacturing Overhead enter a dollar amount 85,400 enter a dollar amount 91,500 select a cash budget item Selling and Administrative Expenses enter a dollar amount 95,160 enter a dollar amount 102,480 select a cash budget item Cash Dividend enter a dollar amount 0 enter a dollar amount 7,320 select a closing name for section two Total Disbursements enter a total amount for section two 427,000 enter a total amount for section two 473,360 select a summarizing line for the second part Excess (Deficiency) of Available Cash Over Cash Disbursements enter a total amount for the second part 62,220. enter a total amount for the second part 50,020.00 select an opening name for section three Financing select between addition and deduction Add : select a cash budget item Borrowings enter a dollar amount enter a dollar amount 10980. select between addition and deduction Less : select a cash budget item Repayments enter a dollar amount 0 enter a dollar amount 57340. select a closing cash budget item Ending Cash Balance $enter a total amount for the cash budget 62,220 $enter a total amount for the cash budget 61,000.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started