Question

In: Accounting

"Mankota Company’s purchasing manager, Fernando Garza, is preparing a purchases budget for the next quarter. At...

"Mankota Company’s purchasing manager, Fernando Garza, is preparing a purchases budget for the next quarter. At his request, Ruben Carpenter, the manager of the sales department, forwarded him the following preliminary sales budget: Preparing an inventory purchases budget and schedule of cash payments Budgeted sales October $240,000 November $300,000 December $360,000 January$320,00" "For budgeting purposes, Mankota estimates that cost of goods sold is 75 percent of sales. The company desires to maintain an ending inventory balance equal to 20 percent of the next period’s cost of goods sold. The September ending inventory is $40,000. Mankota makes all pur-chases on account and pays 70 percent of accounts payable in the month of purchase and the remaining 30 percent in the following month. The balance of accounts payable at the end of September is $37,500.Required a. Prepare an inventory purchases budget for October, November, and December.b. Determine the amount of ending inventory Mankota will report on the end-of-quarter pro forma balance sheet.c. Prepare a schedule of cash payments for inventory for October, November, and December.d. Determine the balance in accounts payable Mankota will report on the end-of-quarter pro forma "

Solutions

Expert Solution


Related Solutions

Green Landscaping Inc. is preparing its budget for the first quarter of 2017. The next step...
Green Landscaping Inc. is preparing its budget for the first quarter of 2017. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected. Clients usually pay 60% of their fee in the month that service is performed, 30% the month after, and 10% the second month after receiving service. Actual service revenue for 2016 and expected service revenues for 2017 are November...
Green Landscaping Inc. is preparing its budget for the first quarter of 2020. The next step...
Green Landscaping Inc. is preparing its budget for the first quarter of 2020. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected. Clients usually pay 60% of their fee in the month that service is performed, 30% the month after, and 10% the second month after receiving service. Actual service revenue for 2019 and expected service revenues for 2020 are November...
Green Landscaping Inc. is preparing its budget for the first quarter of 2020. The next step...
Green Landscaping Inc. is preparing its budget for the first quarter of 2020. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected. Clients usually pay 60% of their fee in the month that service is performed, 30% the month after, and 10% the second month after receiving service. Actual service revenue for 2019 and expected service revenues for 2020 are November...
Green Landscaping Inc. is preparing its budget for the first quarter of 2020. The next step...
Green Landscaping Inc. is preparing its budget for the first quarter of 2020. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected. Prepare schedules for cash receipts and cash payments, and determine ending balances for balance sheet. Clients usually pay 60% of their fee in the month that service is performed, 30% the month after, and 10% the second month after...
Novak Landscaping Inc. is preparing its budget for the first quarter of 2017. The next step...
Novak Landscaping Inc. is preparing its budget for the first quarter of 2017. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected. Clients usually pay 60% of their fee in the month that service is performed, 30% the month after, and 10% the second month after receiving service. Actual service revenue for 2016 and expected service revenues for 2017 are November...
Green Landscaping Inc. is preparing its budget for the first quarter of 2017. The next step...
Green Landscaping Inc. is preparing its budget for the first quarter of 2017. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected. Clients usually pay 60% of their fee in the month that service is performed, 30% the month after, and 10% the second month after receiving service. Actual service revenue for 2016 and expected service revenues for 2017 are November...
Green Landscaping Inc. is preparing its budget for the first quarter of 2017. The next step...
Green Landscaping Inc. is preparing its budget for the first quarter of 2017. The next step in the budgeting process is to prepare a schedule of cash collections and a schedule of cash payments. The following information has been collected: All sales are on account and 60% is collected in the month of sale, 30% 1 month after the sale, and 10% two months after the sale. Actual sales revenues for November 2016 were $80,000 and December 2016 $90,000. Projected...
Green Landscaping Inc. is preparing its budget for the first quarter of 2017. The next step...
Green Landscaping Inc. is preparing its budget for the first quarter of 2017. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected. Clients usually pay 60% of their fee in the month that service is performed, 30% the month after, and 10% the second month after receiving service. Actual service revenue for 2016 and expected service revenues for 2017 are November...
Soprano Co. is in the process of preparing the second quarter budget for 2016, and the...
Soprano Co. is in the process of preparing the second quarter budget for 2016, and the following data have been assembled: The company sells a single product at a selling price of $43 per unit. The estimated sales volume for the next six months is as follows: March 6,100 units June 8,000 units April 7,000 units July 9,300 units May 10,400 units August 6,400 units All sales are on account. The company's collection experience has been that 43% of a...
Freese, Inc., is in the process of preparing the fourth quarter budget for 2016, and the...
Freese, Inc., is in the process of preparing the fourth quarter budget for 2016, and the following data have been assembled: The company sells a single product at a price of $61 per unit. The estimated sales volume for the next six months is as follows: September 7,800 units October 7,200 units November 8,400 units December 12,000 units January 5,400 units February 6,000 units All sales are on account. The company's collection experience has been that 30% of a month's...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT