ABC Company has prepared a unit sales budget for the upcoming months as follows:MonthUnitsMonthUnitsJanuary.5,000June,30,000February.7,500July35,000March.10,000August..25.000April.15,000September.10,000May.20,000October.6,000ABC has a policy to maintain ending inventory levels equal to 30% of the coming month's sales requirements. Inventory on January 1 is projected to be 1,200 units.Required:Fill-in the missing amounts in the production budget of ABC Company for the next six months.ABC CompanyProduction BudgetJanuary5,000February7,500MarchApril15,000May20,000JuneSales.10,00030,000Ending inventory .9.000Total needs.10,50014.50021,00029,00040,500Less: Beginning inventory..1.200Units to be produced.6.05011,500

Production Budget refers to the financial plan which lists the no of units to be manufactured during…

Answered: Fill-in the missing amounts in the…

Business

Accounting

Fill-in the missing amounts in the production budget of ABC Company for the next six months.

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

Assume that sales and expenses forecasts for months April, May, June, and July are as follows. month, 60% are paid in the next month, and 20% are paid in the second month after. All expenses in a month are paid in the same month. There is a $20,000,000 minimum required cash balance at the end of each month, and any shortage from this minimum requirement will be covered by obtaining a loan. Any excess over $20,000,000 will be used to reduce or pay off cumulative loan. Initial cash balance in June is $6,000,000 and there is no cumulative loan at this time. Monthly prorated tax rate is 2%, and monthly interest rate on cumulative loan is 1%. Requirements: Prepare cash budget proforma for months June and July and interpret the result in detail.
please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image) QUESTION 2 In the late June of each year, BOS Global Ltd prepares a cash budget for the next 6 months. The entity’s management wishes to prepare a cash budget in order to assess its likely requirements for short-term funds. Actual sales for May, and estimated sales for June, and for the next 7 months are as follows: Months Sales Revenues (Actual and Estimates) [GHS] Months Sales Revenues (Actual and Estimates) [GHS] May 20,000 September 50,000 June 28,000 October 94,000 July 24,000 November 74,000 August 26,000 December 52,000 January 40,000 Approximately 25 per cent of sales are for cash and 75 per cent are on credit. Past experience has shown that two-third of all credit sales are collected in the month immediately following the month of…
Problem 1. On a separate sheet of paper, prepare a cash budget for the first four months of 2006, showing the amount of cumulative excess cash (loan balance). Basic company has planned a cash budget for the first four months. Estimates show that P60,000 should be collected in January and April for the dividends to be received from investments in stock of other companies. Each month, operating expenses for wages, rents, lights and others estimated to be P100,000 plus 10% of the preceding month sales. Sales and collections on accounts receivables are estimated as follows: 50% collected in the month of sale 30% collected in the month following the sale 20% collected in the second month following the sale Payments for the merchandise purchased are scheduled so that 60% of the payments are made in the month of purchase with the balance paid the following month. The cash balance is estimated at P175,000 for January 1, 2006. Estimated net sales and purchases for the months are as follows: Net…
Subject: acounting
Assuming your budgets are stable across the year, how much of your Company's budget do you have left for developing new collateral for the remainder of this month?
Schedule of Cash Payments for a Service Company EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January-March). The Accrued Expenses Payable balance on January 1 is $25,600. The budgeted expenses for the next three months are as follows: January February $58,900 $71,700 $79,400 4,900 5,400 6,400 45,400 49,500 54,500 $109,200 $126,600 $140,300 Other operating expenses include $3,200 of monthly depreciation expense and $700 of monthly insurance expense that was prepaid for the year on May 1 of the previous year. Of the remaining expenses, 80% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December. Salaries Utilities Other operating expenses Total Prepare a schedule of cash payments for operations for January, February, and March. EastGate Physical Therapy Inc. Schedule of Cash Payments for Operations…
At the beginning of the school year, Craig Kovar decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: $6,650 Cash balance, September 1 (from a summer job) Purchase season football tickets in September 90 Additional entertainment for each month 230 Pay fall semester tuition in September 3,600 Pay rent at the beginning of each month 320 Pay for food each month 180 Pay apartment deposit on September 2 (to be returned December 15) 500 Part-time job earnings each month (net of taxes) 820 a. Prepare a cash budget for September, October, November, and December. Use the minus sign to indicate cash outfiows, a decrease in cash or cash payments. Craig Kovar Cash Budget For the Four Months Ending December 31 Line Item Description Estimated cash receipts from: Total cash recei Less…
Don't give answer in image format
Please do not give image format
The budget director for Rundle Cleaning Services prepared the following list of expected selling and administrative expenses. All expenses requiring cash payments are paid for in the month incurred except salary expense and insurance. Salary is paid in the month following the month in which it is incurred. The insurance premium for six months is paid on October 1. October is the first month of operations, accordingly, there are no beginning account balances. Required a. Complete the schedule of cash payments for S&A expenses by filling in the missing amounts. b. Determine the amount of salaries payable the company will report on its pro forma balance sheet at the end of the fourth quarter. c. Determine the amount of prepaid insurance the company will report on its pro forma balance sheet at the end of the fourth quarter. Complete this question by entering your answers in the tabs below. Req A Complete the schedule of cash payments for S&A expenses by filling in the missing amounts.…
Harris Inc., has budgeted sales in units for the next five months as follows: June July August September October 9,400 units 7,800 units 7,300 units 5,400 units 4,100 units Past experience has shown that the ending inventory for each month should be equal to 20% of the next month's sales in units. The inventory on May 31 contained 1,880 units. The company needs to prepare a production budget for the next five months.
Gibson is a retail company specializing in men's hats. Its budget director prepared the list of expected operating expenses that follows. All items are paid when incurred except sales commissions and utilities, which are paid in the month following their incurrence. July is the first month of operations, so there are no beginning account balances. Salary expense Sales commissions (4 percent of sales) Supplies expense Utilities Depreciation on store equipment Rent Miscellaneous Total S&A expenses before interest Required a. Prepare a schedule of cash payments for selling and administrative expenses. b. Determine the amount of utilities payable as of September 30. c. Determine the amount of sales commissions payable as of September 30. Complete this question by entering your answers in the tabs below. Req A Req B and C July $18,300 August September $18,300 $18,300 2,800 2,800 2,800 290 320 350 2,500 2,500 2,500 2,700 2,700 2,700 5,700 5,700 5,700 790 790 790 $33,080 $33,110 $33, 140…