**Marlin Company's Projected Costs for Manufacturing and Selling****Overview:**Marlin Company has outlined the following projected costs for manufacturing and associated selling and administrative expenses. This information assists in preparing the schedule of cash payments for January, February, and March.**Instructions:**Prepare a schedule of cash payments for Marlin for the first quarter of the year. Calculate the balances in Prepaid Property Taxes, Accounts Payable, and Utilities Payable as of March 31. Assume operations started in January. Do not enter zeros for unused input fields.**Cash Payments Breakdown:****Direct Materials:**- Accounts Payable balance on January 1: [Input Field]- January — Direct material purchases paid in February: [Input Field]- February — Direct material purchases paid in March: [Input Field]**Total Payments for Direct Materials:**- January: [Input Field]- February: [Input Field]- March: [Input Field]- Total: [Input Field]**Direct Labor:**- Total Payments for Direct Labor: [Input Field per month]**Data Table Explanation:**The data table on the right provides detailed monthly breakdowns for various costs:- **Direct Materials Purchases:** - January: $3,900 - February: $4,100 - March: $4,400- **Direct Labor Costs:** - January: $3,000 - February: $3,400 - March: $3,700- **Depreciation on Plant:** Constant at $200 per month- **Utilities for Plant:** Constant at $950 per month- **Property Taxes on Plant:** Constant at $310 per month- **Depreciation on Office:** Constant at $450 per month- **Utilities for Office:** Constant at $320 per month- **Property Taxes on Office:** Constant at $150 per month- **Office Salaries:** Constant at $5,000 per month**Important Notes:**- All costs are paid in the month incurred, except for direct materials, which are paid in the month following the purchase.- Utilities are paid in the month after incurred.- Property taxes are prepaid for the year on January 2.- The Accounts Payable and Utilities Payable accounts start with a zero balance on January 1.

A schedule of cash payment is the schedule which is prepared with the purpose of recording the purchases made by the company. It is quite similar to the cash collection schedule. However, the cash collection schedule records the sales and it records the purchases.The schedule of cash payments is as follows: The formula snip is as follows:

Business

Accounting

(Click the icon to view the projected costs.) Prepare a schedule of cash payments for Marlin for January, February, and March. Determine the balances in Prepaid Property Taxes, Accounts Payable, and Utilities Payable as of March 31. (Assum the company started operations in January. If an input field is not used in the table leave the input field empty; do not enter a zero.) Cash Payments Direct Materials: Accounts Payable balance, January 1 January-Direct material purchases paid in February February-Direct material purchases paid in March Total payments for direct materials Direct Labor: Total payments for direct labor January February B March Total Data table Direct materials purchases Direct labor costs Depreciation on plant Utilities for plant Property taxes on plant Depreciation on office Utilities for office January February $ 3,900 $ 3,000 200 950 310 450 320 +CO 4,100 $ 3,400 200 950 310 450 320 160 March 4,400 3,700 200 950 310 450 320 150 I

(Click the icon to view the projected costs.) Prepare a schedule of cash payments for Marlin for January, February, and March. Determine the balances in Prepaid Property Taxes, Accounts Payable, and Utilities Payable as of March 31. (Assum the company started operations in January. If an input field is not used in the table leave the input field empty; do not enter a zero.) Cash Payments Direct Materials: Accounts Payable balance, January 1 January-Direct material purchases paid in February February-Direct material purchases paid in March Total payments for direct materials Direct Labor: Total payments for direct labor January February B March Total Data table Direct materials purchases Direct labor costs Depreciation on plant Utilities for plant Property taxes on plant Depreciation on office Utilities for office January February $ 3,900 $ 3,000 200 950 310 450 320 +CO 4,100 $ 3,400 200 950 310 450 320 160 March 4,400 3,700 200 950 310 450 320 150 I

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Schedule of cash payments for a service company Horizon Financial Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: March $152,100 April 139,900 May 127,300 Depreciation, insurance, and property taxes represent $32,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in June. 62% of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month.
Please do not give solution in image format thanku
answer in text form please (without image)
Please do not give image format
Prepare a cash Collection Schedule for Producers Inc. For the months of March, April and May 2022 using the ff. data: Jan Feb Mar Apr P78,300 May P83,000 Sales P75,300 P82,100 P88,000 Cash Basis 30% Credit Basis 70% (50% collected in month of Sales, 30% in month after sale and 20% 2 mos after sale)
Davis and Davis have expected sales of $490, $465, $450, and $570 for the months of January through April, respectively. The accounts receivable period is 28 days. What is the accounts receivable balance at the end of March? Assume a year has 360 days. a. $450 b. $420 c. $440 d. $426
Given: Cash Receipts for September =PHP 305,450; October = PHP 85,405; and November =PHP 375,195. Cash Disbursements for September =PHP 215,485; October = PHP 250,265; and November = PHP 310,525. Beginning Cash Balance (September) = PHP 35,975. Minimum Monthly Cash Balance Needed = PHP 34,425. The ending cash for September is PHP O 160,365 O 125,940 O 89,965 O 91,515
Note:- • Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. • Answer completely. • You will get up vote for sure.
3. Furry Friends Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows:
The following information is from Teas Window’s financial records. The company buys its raw material on account and pays:• 60% of accounts payable during the month of purchase• 35% in the first month after purchase• 5% in the second month after purchaseMonth PurchasesApril 50,000May 52,000June 60,000July 72,000Compute the estimated total cash disbursements during July. Show your calculations
VTV Company has a cash balance of Rs.54,000 at the beginning of September and the following information is available: Creditors give one month credit Salaries are paid in the current month Fixed costs are paid in one month arrears and include a charge for depreciation Rs.10,000 per month Credit sales are settled as follows: 40% in the month of sales, 45% in the next month and 12% in the following month. The balance represents bad debts. Month Cash Sales Credit Sales Purchases Salaries Fixed Overheads July 148,000 110,000 18,000 60,000 August 164,000 122,400 18,000 60,000 September 40,000 160,000 120,000 19,000 60,000 October 44,000 180,000 138,000 19,000 64,000 November 50,000 200,000 150,000 20,000 64,000 Calculate Current month credit sales for each month. Calculate 1st month credit sales for each month Calculate 2nd month credit sales for each month. Calculate Total receipt…
Please do not give solution in image format thanku