Reference no: EM133093764
Question - Carla Vista Company prepares monthly cash budgets. Relevant data from operating budgets for 2022 are as follows.
|
|
January
|
February
|
|
Sales
|
$424,800
|
$472,000
|
|
Direct materials purchases
|
141,600
|
147,500
|
|
Direct labor
|
106,200
|
118,000
|
|
Manufacturing overhead
|
82,600
|
88,500
|
|
Selling and administrative expenses
|
93,220
|
100,300
|
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,180 of depreciation per month.
Other data:
1. Credit sales: November 2021, $295,000; December 2021, $377,600.
2. Purchases of direct materials: December 2021, $118,000.
3. Other receipts: January-Collection of December 31, 2021, notes receivable $17,700; February-Proceeds from sale of securities $7,080.
4. Other disbursements: February-Payment of $7,080 cash dividend.
The company's cash balance on January 1, 2022, is expected to be $70,800. The company wants to maintain a minimum cash balance of $59,000.
Required -
(a) Prepare schedules for (1) expected collections from customers and (2) expected payments for direct materials purchases for January and February.
(b) Prepare a cash budget for January and February in columnar form.
|
Research either qualitatively or quantitatively
: Select a research topic that interests you and research either qualitatively or quantitatively.
|
|
What amount should be reported as total cash on December
: Preference share redemption fund (redemption date May 31, 2024) 2,500,000. What amount should be reported as total cash on December 31, 2022
|
|
Complete the cash flow statement for the year ended June
: The following are the financial statements of Carey Sports and Outdoors Ltd at 30 June 2021: Complete the cash flow statement for the year ended June
|
|
Prepare a cash budget for the six months
: Prepare a cash budget for the six months ending 30 November which shows the cash balance at the end of each month also based on the plans set
|
|
Prepare schedules for expected collections from customers
: Prepare schedules for (1) expected collections from customers and (2) expected payments for direct materials purchases for January and February
|
|
Calculate the required number of customers
: The equipment and furniture purchase would be financed with a 5 year loan at an interest rate of 5.2%. Calculate the required number of customers
|
|
Calculate the cash increase or decrease from financing
: Net cash decrease from investments was $19,000. Based on this information, calculate the cash increase (or decrease) from financing
|
|
What is the total contribution by profit center
: The accounting manager has come up with the following data for the year: contribution margin of $550,000, What is the total contribution by profit center
|
|
Should the bakery make the purchase
: The machine will produce 10,000 donuts per year, with each costing $2.00 to make and priced at $4.00. Should the bakery make the purchase
|