A monthly cash budget for Gomez's Fish Market for the first quarter of 2022 needs to...

Transcribed Image Text:

A monthly cash budget for Gomez's Fish Market for the first quarter of 2022 needs to be prepared. Cash on January 1, 2022, is $10,000. (20 pts) Total monthly sales are as follows: November 2021 $100,000 December 2021 120,000 January 2022 (est.) 110,000 February 2022 (est.) 130,000 March 2022(est.) 120,000 April 2022 (est.) 140,000 The sales are 40% cash and 60% credit card. American Express is the only acceptable credit card at Gomez's, and the charges are converted to cash the day after the sale. Assume the sales are even throughout the month, and that the brokerage charge is 3%. Expected other income is $2,000 from interest to be received in February. In addition, in February a range with a net book value of $400 is expected to be sold for cash at a $600 gain on the sale. Food and beverages are paid for the month following the sale and average 35% of sales. Labor is paid for the last day of the month and averages 40% of sales. Other expenses approximate $10,000 per month. During January, equipment costing $15,000 is to be purchased and paid for. In February, $30,000 is expected to be expended on new equipment. Funding for this expenditure in part comes from a long-term loan of $15,000 from Delaware National Bank. A monthly cash budget for Gomez's Fish Market for the first quarter of 2022 needs to be prepared. Cash on January 1, 2022, is $10,000. (20 pts) Total monthly sales are as follows: November 2021 $100,000 December 2021 120,000 January 2022 (est.) 110,000 February 2022 (est.) 130,000 March 2022(est.) 120,000 April 2022 (est.) 140,000 The sales are 40% cash and 60% credit card. American Express is the only acceptable credit card at Gomez's, and the charges are converted to cash the day after the sale. Assume the sales are even throughout the month, and that the brokerage charge is 3%. Expected other income is $2,000 from interest to be received in February. In addition, in February a range with a net book value of $400 is expected to be sold for cash at a $600 gain on the sale. Food and beverages are paid for the month following the sale and average 35% of sales. Labor is paid for the last day of the month and averages 40% of sales. Other expenses approximate $10,000 per month. During January, equipment costing $15,000 is to be purchased and paid for. In February, $30,000 is expected to be expended on new equipment. Funding for this expenditure in part comes from a long-term loan of $15,000 from Delaware National Bank.