Problem 5-A (Projected Income Statement) MAXI Co. has the following information: ● Projected sales for four (4) months are as follows: July 20,000 units; August - 35,000 units; September - 25,000; October - 30,000. Sales price per unit is P180. Plans are to have a finished goods inventory end equal to 20% of the unit sales for next month. There was 4,000 units in beginning inventory on July 1. Three (3) kilos of materials are required per unit produced. Every kilo of material is P20. Raw material inventory must be equal to 30% of the next month's needs. Desired ending inventory for September is 25,200 kilos and beginning inventory was 20,700 kilos Each unit requires 0.60 hours of direct labor and the average wage rate is P16 per hour. Variable overhead rate is P3.50 per direct labor hour. There is also a fixed overhead of P22,000 per month. The company pays 3% commission on sales. Company has a monthly fixed and selling expenses as follows: Rent P6,000; Utilities - P1,200; Advertising - P400; Office Salaries - P35,000. Income tax rate @ 35% Requirement: Prepare the operating budget and the necessary schedule for the 3rd quarter.

Problem 5-A (Projected Income Statement) MAXI Co. has the following information: ● Projected sales for four (4) months are as follows: July 20,000 units; August - 35,000 units; September - 25,000; October - 30,000. Sales price per unit is P180. Plans are to have a finished goods inventory end equal to 20% of the unit sales for next month. There was 4,000 units in beginning inventory on July 1. Three (3) kilos of materials are required per unit produced. Every kilo of material is P20. Raw material inventory must be equal to 30% of the next month's needs. Desired ending inventory for September is 25,200 kilos and beginning inventory was 20,700 kilos Each unit requires 0.60 hours of direct labor and the average wage rate is P16 per hour. Variable overhead rate is P3.50 per direct labor hour. There is also a fixed overhead of P22,000 per month. The company pays 3% commission on sales. Company has a monthly fixed and selling expenses as follows: Rent P6,000; Utilities - P1,200; Advertising - P400; Office Salaries - P35,000. Income tax rate @ 35% Requirement: Prepare the operating budget and the necessary schedule for the 3rd quarter.

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

A company has completed the operating budget and the cash budget. It is now preparing the budgeted balance sheet. Please use the below image as your guide for the next 5 questions. )dentify the document that contains accounts receivable A B C D E
What about preparing a schedule of expected cash disbursement for merchandise purchases, by month and the total and budgeted income statement for the three-month period ending June 30.
The following information is available from various budgets for the current period: Amount Budget Cash budget Account Cash Accounts Receivable Prepaid Insurance Equipment Accumulated Depreciation - Equipment Schedule of cash receipts from customers Inventory, purchases, and cost of goods sold budget Selling and administrative expense budget Capital expenditures budget OA. $173,000 OB. $164,000 OC. $159,000 O D. $162,000 $28,000 Merchandise Inventory Insurance Expense (expense incurred during the period) Equipment Depreciation Expense Equipment (expense incurred during the period) Selling and administrative expense budget 2,000 The following balances are available from the balance sheet at the end of the previous year: $5,000 28,000 7,000 What would be the amount of total assets on the budgeted balance sheet? 35,000 41,000 2,000 36,000
Prepare a cash budget for January and February in columnar form. Please answer in detail with all working please answer in text not image
Required: Prepare Shadee's budgeted income statement for the months of May and June. Note: Do not round your intermediate calculations. Round your answers to 2 decimal places. Budgeted Gross Margin SHADEE CORPORATION Budgeted Income Statement Budgeted Net Operating Income May June
The income statement for the first quarter of 2019 was as follows: Income Statement For the Quarter Ended March 31, 2019 Sales Cost of goods sold Gross profit Operating expenses ales salaries Rent expense Depreciation Utilities Miscellaneous Total operating expenses Net income $52,000 24,000 12,000 3,600 12,800 $720,000 396,000 324,000 104,400 $219,600 Prepare a budgeted quarterly income statement in tabular form for the first quarter of 2020.
Perez Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a specialty sales company that sells laser pointers over the Internet. Perez expects sales in January year 1 to total $210,000 and to increase 20 percent per month in February and March. All sales are on account. Perez expects to collect 68 percent of accounts receivable in the month of sale, 24 percent in the month following the sale, and 8 percent in the second month following the sale. Required Prepare a sales budget for the first quarter of year 1. Determine the amount of sales revenue Perez will report on the year 1 first quarterly pro forma income statement. Prepare a cash receipts schedule for the first quarter of year 1. Determine the amount of accounts receivable as of March 31, year 1. Complete this question by entering your answers in the tabs below. Prepare a sales budget for the first quarter of year 1.
How do I prepare the cash budget for the quarter ended March 31, 20X1?
please explain step-by-step how to calculate an operational budget with the information provided: The time window would be in a year of operation total expenses for the year would be $22,298.57 projected income for the year would be $64,000
1. Prepare a budgeted income statement for the month ended July 31st. Use an absorption format. a. Calculate the estimated operating cycle for the month of July. (Hint: Use 30 days in the numerator to calculate the average collection period and the average sales period.)
1. Prepare Grayson's operating budget and cash budget for 2025 by quarter. Required schedules and budgets include: sales budget, production budget, direct materials budget, direct labor budget, manufacturing overhead budget, cost of goods sold budget, selling and administrative expense budget, schedule of cash receipts, schedule of cash payments, and cash budget. Manufacturing overhead costs are allocated based on direct labor hours. Round all calculations to the nearest dollar. 2. Prepare Grayson's annual financial budget for 2025, including budgeted income statement and budgeted balance sheet. --------------------------------------------------------------------------------------------------------------------- The Grayson Tire Company manufactures racing tires for bicycles. Grayson sells tires for $70 each. Grayson is planning for the next year by developing a master budget by quarters. Grayson's balance sheet for December 31, 2024, is as follows: Grayson…
Can you show how you got the numbers for question 6? Can you show me how to prepare the following: Prepare a selling and administrative expenses budget for January Prepare a budgeted income statement for January