payments. The October purchases is set at P150,000, and purchases increase by 20% based on the previous month. 50% of purchases are paid on the month of purchase,
Q: Time le Sales in July was US$50,000. The company's collection policy is like this, 30% in the month…
A: Sales represents the revenue that a company is able to generate by selling the core business…
Q: The following sales and purchases are expected over the Five-month period from November 2019 to…
A: Cash budget of the business shows expected cash receipts and cash payments for the future period of…
Q: Equarter by month. Cash sales are 10% of total sales each month. Historically, sales on ccount lave…
A: The cash collection schedule is prepared to estimate the cadh collection during the period.
Q: National Co. sells on terms 3/10, net 30. Total sales for the year are P900,000. Thirty-five percent…
A: Sales = P 900000 35% pay on 10th day and 65% pay on 45th day. Let's find the days sales outstanding.
Q: Data regarding a company's monthly sales for the last six months of the year and its projected…
A: Budgeted Cash receipts for September = (Budgeted credit Sales for August X 57%) + (Budgeted Sales…
Q: Frank's Sporting Goods projects sales for the second quarter of 200X to be as follows:…
A: Schedule of cash receipts is made to ascertain the amount received in the particular months.
Q: Johns industries expects to purchase $160000 of materials in July and $180000 of materials in…
A: The correct option is (2) $175,000. Disbursement of cash refers to the outflow of cash for providing…
Q: (a) Anusha Berhad's sales pattern for the first quarter 2021 and projected revenues are as follows:…
A: Budget: A budget is an estimation to determine the income that will be earned and expenses that will…
Q: A company has advance subscription sales totaling $45,000 for the upcoming year when four quarterly…
A:
Q: what are the expected cash payments in July?
A: In the given case, Purchases in june = P130000 Purchases in july = P124000 Given that NUBD pays for…
Q: PT AWOL has sales projections (in million rupiahs) for the following four quarters: Q1 Q2 Q3 Q4…
A: A cash budget is prepared to present all the expected receipts, payments, and the cash balance at…
Q: A firm has actual sales in November of $1,000 and projected sales in December and January of $3,000…
A: Credit sales refer to the sales in which the customer is given some time to pay for the goods…
Q: Sales for April, May, June, and July will be $310,000, $330,000, $320,000, and $340,000,…
A: Account receivable shows the amount of sales which is not received yet. In simple, it represents the…
Q: A company's sales for the coming months are as follows: April, P175,000 June, P140,000 August,…
A: The Cash Budget is the total estimation of the total cash receipts and the total cash to be disburse…
Q: Miggy Co. projects the following monthly revenues for next year: 100,000 500,000 452,000 450,000…
A: Formula: Cash collection amount : Credit sales x cash collection %
Q: on credit control would amount to £50,000. The average number of days to pay for the remaining 80%…
A: Assumption to make that the credit preiod reduced by given the discount . Where the company expected…
Q: Dolittle and Dalley has $4,000 in purchases for January and $5,000 in purchases for February. It…
A: January month accounts receivable = January sales × ( 100 % - percentage collected in the month…
Q: During the next four months, a furniture manufacturer will be entering its holiday season.…
A: The annual percentage rate seems to be the cost of credit, expressed as a percentage, over a year.…
Q: A bill for Php10,240 was due on July 1. Purchases of Php3,150 were made on July 7, and Php4,100 was…
A: Hi There, Thanks for posting the questions. As per our Q&A guidelines, must be answered only one…
Q: 1. A company has a sales plan for 2020 based on the estimated end of the month as follows: Month…
A: The accounts receivables represent the amount due from customers for sales made by the company on…
Q: Planet Company purchased goods worth $50,000 in July and expects to purchase goods worth $70,000 in…
A: Solution:- Computation of total expected cash disbursement for the month of August as follows…
Q: Halifax Shoes has 39% of its sales in cash and the remainder on credit. Of the credit sales, 65% is…
A: Budgeting is an important part of the business process. Without budgeting a business cannot track…
Q: Miggy Co. projects the following monthly revenues for next year: 100,000 500,000 452,000 450,000…
A: Formula: Cash collection amount = Credit sales x Cash collection %
Q: Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is…
A: Cash sales in August = Total sales x 30% = $95,000 x 30% = $28,500
Q: Lux Co. sells on terms 3/10, net 30. Total sales for the year are P900,000. Thirty-five percent of…
A: Sales per day = Total sales / 360 Sales per day = P900,000 / 360 Sales per day = P2,500 Days' sales…
Q: Sy Co. has the collection schedule of 65% during the month of sales, 15% the following month, and…
A: In the given question, it is specified that 65% of credit sales of a month are collected in that…
Q: The following are forecasts of sales and purchases for KWANGYA Company: Sales Purchases April…
A: Cash flows are the cash generated from the operation of the business organisation. In other words,…
Q: Samgyupsalamat mployees are given 10% commissions based on sales made every quarter starting January…
A: Commissions are a form of variable-pay remuneration for services rendered or products sold.…
Q: Sonia Sdn Bhd makes all of its purchases on credit; 50% are paid in the month of purchase, 30%…
A: Here in this question, we are required to calculate creditor at the end of March. Budget is a…
Q: Spalding Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a…
A: GIVEN Spalding Pointers Corporation expects to begin operations on January 1, year1; it will…
Q: Projector Limited has the following projection for the 4 months ending August 2018: May June July…
A: A cash budget is a plan to identify the inflows and outflows of cash in an organization. It helps…
Q: The following sales and purchases are expected over the Four-month period from December to March…
A: The questions are multiple choice questions Required Choose the Correct Option.
Q: The following sales and purchases are expected over the Four-month period from December to March…
A: Cash budget of the business shows expected cash receipts and cash disbursements of the business for…
Q: How much is the VAT Payable in May? Given the following data during the 2nd quarter of 2022 Month…
A: VAT or Value added tax is an Indirect tax which is imposed on Goods and Services. Net VAT payable is…
Q: Reed Merchandising Company expects to purchase P90,000 of materials in July and P105,000 of…
A: The cash budget is prepared to record the cash receipts and payment made during the period.
Q: If a firm had credit sales of $1,550,000 for March and collected its sales 30% in the month of sale…
A: March sales collected in March = Credit March sales x 30%
Q: The Amber Magick Shoppe has forecast its sales revenues and purchases for the last 5 months of 200x…
A: Budget is an estimated schedule of estimated receipts and estimated payments during the particular…
Q: The table contains the Sales estimates for the next year. The Purchases are 55% of Sales.…
A: Outflow of cash refers to the cash going out of the business. It includes the amount of money paid…
Q: Miggy Co. projects the following monthly revenues for next year: 100,000 500,000 452,000 450,000…
A: Working
Q: The following sales and purchases are expected over the Four-month period from December to March…
A: Cash budget is very important budget in the business which shows that how much cash is expected to…
Q: The Clinton Antique Mall expects to make purchases in the first quarter of 2021 as follows: January…
A: Lets understand the basics. Management prepares cash collection and cash payment schedule in order…
Q: Eddie's Bar and Restaurant Supplies expects its revenues and payments for the first part of the year…
A: Formula: Cash received amount = Total sales x collectible percentage of sales amount for the month.…
Step by step
Solved in 2 steps
- Relevant data from the Poster Companys operating budgets are: Additional data: Capital assets were sold in January for $10,000 and $4,500 in May. Dividends of $4,500 were paid in February. The beginning cash balance was $60,359 and a required minimum cash balance is $59,000. Use this information to prepare a cash budget for the first two quarters of the yearShalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the follow sales: In Shalimars experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are 4,900,000 and for the fourth quarter of the current year are 6,850,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. 2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from credit sales. 3. What if the recession led Shalimars top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised cash budget using the new assumption.Cash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent 50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1 include cash of 40,000, marketable securities of 75,000, and accounts receivable of 300,000 (60,000 from July sales and 240,000 from August sales). Sales on account for July and August were 200,000 and 240,000, respectively. Current liabilities as of September 1 include 40,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 55,000 will be made in October. Bridgeports regular quarterly dividend of 25,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of 50,000. Instructions Prepare a monthly cash budget and supporting schedules for September, October, and November. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?
- All Temps has a policy of always paying within the discount period, and each of its suppliers provides a discount of 2% if paid within 10 days of purchase. Because of the purchase policy, 80% of its payments are made in the month of purchase and 20% are made the following month. The direct materials budget provides for purchases of $23,812 in February, $23,127 in March, $21,836 in April, and $28,173 in May.What is the balance in accounts payable for April 30, and May 31?A companys controller is adjusting next years budget to reflect the impact of an expected 3 percent inflation rate. Listed below are selected items from next years budget before the adjustment. After adjusting for the 3 percent inflation rate, what is the companys total budget for the selected items before taxes for next year? a. 858,150 b. 860,412 c. 810,971 d. 858,971Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $75,000 in June, $65,000 in July, and $90,000 in August?
- Cash budget The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the sale and the remainder the following month (second month after sale). Depreciation, insurance, and property tax expense represent 12,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in February, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of June 1 include cash of 42,000, marketable securities of 25,000, and accounts receivable of 198,000 (150,000 from May sales and 48,000 from April sales). Sales on account in April and May were 120,000 and 150,000, respectively. Current liabilities as of June 1 include 13,000 of accounts payable incurred in May for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 24,000 will be made in July. Mercury Shoes regular quarterly dividend of 15,000 is expected to be declared in July and paid in August. Management desires to maintain a minimum cash balance of 40,000. Instructions Prepare a monthly cash budget and supporting schedules for June, July, and August. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?Carmichael Corporation is in the process of preparing next years budget. The pro forma income statement for the current year is as follows: Required: 1. What is the break-even sales revenue (rounded to the nearest dollar) for Carmichael Corporation for the current year? 2. For the coming year, the management of Carmichael Corporation anticipates an 8 percent increase in variable costs and a 60,000 increase in fixed expenses. What is the break-even point in dollars for next year? (CMA adapted)CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2019 and 2020: Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2019. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal, and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.
- 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?Cash collections for Renew Lights found that 65% of sales were collected in the month of sale, 25% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in March and April?The sales department of Macro Manufacturing Co. has forecast sales for its single product to be 20,000 units for June, with three-quarters of the sales expected in the East region and one-fourth in the West region. The budgeted selling price is 25 per unit. The desired ending inventory on June 30 is 2,000 units, and the expected beginning inventory on June 1 is 3,000 units. Prepare the following: a. A sales budget for June. b. A production budget for June.