Pink Martini Corporation is projecting a cash balance of $32,000 in its December 31, 2019, balance sheet. Pink Martini's schedule of expected collections from customers for the first quarter of 2020 shows total collections of $183,000. The schedule of expected payments for direct materials for the first quarter of 2020 shows total payments of $43,000. Other information gathered for the first quarter of 2020 is as follows: sale of equipment $2,000; direct labour $80,000, manufacturing overhead $33,000; selling and administrative expenses $40,000; and purchase of securities $12.000. Pink Martini wants to maintain a balance of at least $23.000 cash at the end of each quarter. Prepare a cash budget for the first quarter.

Pink Martini Corporation is projecting a cash balance of $32,000 in its December 31, 2019, balance sheet. Pink Martini's schedule of expected collections from customers for the first quarter of 2020 shows total collections of $183,000. The schedule of expected payments for direct materials for the first quarter of 2020 shows total payments of $43,000. Other information gathered for the first quarter of 2020 is as follows: sale of equipment $2,000; direct labour $80,000, manufacturing overhead $33,000; selling and administrative expenses $40,000; and purchase of securities $12.000. Pink Martini wants to maintain a balance of at least $23.000 cash at the end of each quarter. Prepare a cash budget for the first quarter.

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 11EB: Gear Up Co. pays 65% of its purchases in the month of purchase, 30% in the month after the purchase,...

See similar textbooks

Similar questions

Gear Up Co. pays 65% of its purchases in the month of purchase, 30% in the month after the purchase, and 5% in the second month following the purchase. What are the cash payments if it made the following purchases in 2018?
Sheridan Corporation is projecting a cash balance of $32,100 in its December 31, 2019, balance sheet. Sheridan’s schedule of expected collections from customers for the first quarter of 2020 shows total collections of $197,950. The schedule of expected payments for direct materials for the first quarter of 2020 shows total payments of $46,010. Other information gathered for the first quarter of 2020 is sale of equipment $3,210; direct labor $74,900, manufacturing overhead $37,450, selling and administrative expenses $48,150; and purchase of securities $14,980. Sheridan wants to maintain a balance of at least $26,750 cash at the end of each quarter.Prepare a cash budget for the first quarter.
Crane Corporation is projecting a cash balance of $31,800 in its December 31, 2024, balance sheet. Crane's schedule of expected collections from customers for the first quarter of 2025 shows total collections of $196, 100. The schedule of expected payments for direct materials for the first quarter of 2025 shows total payments of $45, 580. Other information gathered for the first quarter of 2025 is sale of equipment $3, 180; direct labor $74, 200, manufacturing overhead $ 37,100, selling and administartive expenses $47,700; and purchase of securities $14,840. Crane wants to maintain a balance of at least $26, 500 cash at the end of the quarter. Prepare a cash budget for the first quarter.
The following information was extracted from NOVO cash budget for July 2019. The following data are as follows: Excess of cash available over disbursements is P700; cash balance as of July 1, 2019 is P 5,000 and a total cash disbursement for July is P22,500. The business can only borrow in round figures of P1,000 amounts. If the business is required to maintain a minimum cash balance of P100,000, how much money should be borrowed in July?
Suppose that the Sales in December 2019 were 26,630. The sales are expected to grow by 7% in January 2020, by 5% in February 2020, and by 5% in March 2020. After that, the sales are expected to grow by 11%. The company's cash collection is as follows: 71% is collected in the same month and the remainder in the next month. What is the cash collection for July, 2020?
Suppose that the Sales in December 2019 were 41,498. The sales are expected to grow by 5% in January 2020, by 10% in February 2020, and by 15% in March 2020. After that, the sales are expected to grow by 9%. The company's cash collection is as follows: 24% is collected in the same month, 47% is collected in the next month, and the remainder in the following month. What is the cash collection for July, 2020?
Suppose that the Sales in December 2019 were 86,536. The sales are expected to grow by 9% in January 2020, by 14% in February 2020, and by 15% in March 2020. After that, the sales are expected to grow by 10%. The company's cash collection is as follows: 60% is collected in the same month and the remainder in the next month. What is the cash collection for June, 2020?
Suppose that the Sales in December 2019 were 78,893. The sales are expected to grow by 15% in January 2020, by 4% in February 2020, and by 5% in March 2020. After that, the sales are expected to grow by 4%. The company's cash collection is as follows: 22% is collected in the same month, 22% is collected in the next month, and the remainder in the following month. What is the cash collection for June, 2020?
Mr. James Pastor, a financial analyst for ABC Company, has prepared the following actual sales and cash disbursement for the months of August to September 2020 and estimates for the months of October to December of the current year: Month Sales: August P5,000,000; September P6,000,000; October P4,000,000; November P2,000,000; and December P2,000,000 Cash Disbursements: August P4,000,000; September P3,000,000; October P6,000,000; November P5,000,000; and December P2,000,000. Pastor notes that historically, 30% of sales have been for cash. Of credit sales, 70% are collected 1 month after the sale, and the remaining 30% are collected 2 months after the sale. The firm wishes to maintain a monthly minimum cash balance of P250,000. Balances above this amount would be invested in short-term government securities (marketable securities) whereas any deficits would be financed through short-term bank borrowings (notes payable). The beginning cash balance at October 1 is P1,200,000.a. Prepare…
Adeline Sdn Bhd has engaged you to prepare its cash budget for July 2021. The following is the information extracted from its management report: May 2021 June 2021 July 2021 Credit sales 500,000 450,000 600,000 Purchases of direct material 300,000 500,000 550,000 Expenses 80,000 Other receipts: Sale of investments 30,000 Other payments: Purchase of van 60,000 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. Of direct material purchases, 40% are paid in cash in the month of purchase, and the balance due is paid in the month following the purchase. All other items and expenses above are paid in the month incurred. The cash balance on 1 July 2021 is expected to be RM60,000. Adeline wants to maintain a minimum cash balance of RM50,000. Required: How much will Adeline receive in…
Serendipity, Inc. prepared cash estimates for the 3rd quarter of 2021 (3-months). The following estimates were developed for certain items: July August September Cash sales P 60,000 P 80,000 P 150,000 Credit sales 30,000 60,000 90,000 Purchases 60,000 55,000 75,000 Payroll 40,000 50,000 60,000 Other expenses 20,000 25,000 30,000 In June, credit sales totaled P50,000 and purchases totaled P60,000. May credit sales were P70,000. Accounts receivable collections amount to 50% in the month after the…
Blue Devil Inc. expects the following cash receipts and disbursements during the first quarter of 2021 (receipts exclude new borrowings and disbursements exclude interest payments on borrowings since January 1, 2021): January February March Cash Receipts $430,000 $440,000 $400,000 Cash Disbursements $390,000 $520,000 $420,000 The expected cash balance at January 1, 2021, is $75,000. Blue Devil Inc. wants to maintain a cash balance at the end of each month of at least $60,000. Short-term borrowings at 1% interest per month will be used to accomplish this, if necessary. Borrowings (in multiples of $1,000) will be made at the beginning of the month in which they are needed, with interest for that month paid at the end of the month. Required: Prepare a cash budget for the quarter ended March 31, 2021 using the following Table. Blue Devil Inc.…