Problem Solving: In a Worksheet, Answer the Following: Your grouping as per the Entrepreneurship need to be utilized to clear out all the problems stated here. Only 1 member will submit the Performance Task in Paper, however, any feedback on any member not performing their part, will have to be submitted too. 1 Martin is retailer, engaged in selling sumptuous deserts. Martin sells four products as of the moment, Toasted Pastillas, yema Balls, Red Velvet Crinkles and Sylvanas. Martin wants to prepare a sales budget for the fourth quarter of 2014 in order to properly anticipate his inflows of revenue Sales Forecast in per pack of each product is as follows: October November December Toasted Pastillas 15000 24000 42000 Yema Balls Martin sells the products under the following prices: Toasted Pastillas - P120/pack Yema Balls-P 100/pack 18000 18500 20000 Red Velvet Crinkles 12000 14000 18000 Sylvanas Red Velvet Crinkles - P180/pack Sylvanas-P 200/pack Prepare Martin's Sales Budget for the fourth quarter of 2014 6500 5000 7000

Problem Solving: In a Worksheet, Answer the Following: Your grouping as per the Entrepreneurship need to be utilized to clear out all the problems stated here. Only 1 member will submit the Performance Task in Paper, however, any feedback on any member not performing their part, will have to be submitted too. 1 Martin is retailer, engaged in selling sumptuous deserts. Martin sells four products as of the moment, Toasted Pastillas, yema Balls, Red Velvet Crinkles and Sylvanas. Martin wants to prepare a sales budget for the fourth quarter of 2014 in order to properly anticipate his inflows of revenue Sales Forecast in per pack of each product is as follows: October November December Toasted Pastillas 15000 24000 42000 Yema Balls Martin sells the products under the following prices: Toasted Pastillas - P120/pack Yema Balls-P 100/pack 18000 18500 20000 Red Velvet Crinkles 12000 14000 18000 Sylvanas Red Velvet Crinkles - P180/pack Sylvanas-P 200/pack Prepare Martin's Sales Budget for the fourth quarter of 2014 6500 5000 7000

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

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?
Hi, I'm trying to figure out what the beginning finished goods inventory balance is for June and the units of beginning raw materials inventory for June, based on the information given in the attached picture. I need to create a production budget and a direct materials budget for the quarter, but need those two June balances to finish the budgets.
RequiredPrepare cash budget, for the three month from October to December showing cash balance at the end of December .
Based on the preceding projections and budget requirements for Thingone and Thingtwo, prepare the following budgets for 2017: *Direct material purchases budget (in dollars)
Schedules of Expected Cash Collections and Disbursements; Budgeted Income Statement and Budgeted Balance Sheet. Crow Enterprises is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company's balance sheet as of June 30th is shown below: Crow Enterprises Balance Sheet June 30 Assets $ 80,000 135,000 41,250 Plant and equipment, net of depreciation_211,000 $ 457,250 Cash Accounts receivable Inventory Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings $ 72,000 345,000 50,250 Total liabilities and stockholders' equity $ 467,250 Crow's managers have made the following additional assumptions and estimates: 1. Estimated sales for July, August, September, and October will be $220,000, $240,000, $230,000, and $250,000, respectively. 2. All sales are on credit and all credit sales are collected. Each month's credit sales are collected 35% in the month of sale and 65% in the month following the…
Estimating a cost function. The controller of the Javier Company is preparing the budget for 2018 and needs to estimate a cost function for delivery costs. Information regarding delivery costs incurred in the prior two months are:
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.)
4G . 4G S 9:58 以令 Shrek & Fiona Company Statement of Financial Position As of December 31, 2020 Current Assets Current Liabilities Cash 18,000 Accounts Payable (N2) 240,000 Accounts Receivable (N1) Taxes Payable Dividends Payable 1,192,000 13,200 Less: Uncollectible accounts (22,400) 1,169,600 500,000 Inventories Total Current Liabilities 753,200 Raw Materials (12,000 pounds) 30,000 Finished Goods (4,000 units) 140,000 170,000 Total Current Assets 1,357,600 Stockholder's Equity Common Stock (100,000 shares) 500,000 Non-current Assets Retained Earnings 360,400 Property, plant, and equipment 320,000 Total Stockholder's Equity 860,400 Less: Accumulated depreciation (64,000) 256,000 Total Assets 1,613,600 Total Liabilities and SHE 1,613,600 N1 2020 3rd quarter sales P2,500,000 2020 4th quarter sales P3,100,000 200,000 992,000 1,192,000 75,000 165,000 N2 2020 3rd quarter purchases P300,000 2020 4th quarter purchases P330,000 240,000 1. Estimated unit sales for the first quarter of 2021 is…
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…
Q. prepare Direct material usage budget and direct material purchases budget in both units and dollars; round to dollars for june.
Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow: • Sales are budgeted at $350,000 for November, $370,000 for December, and $360,000 for January. • Collections are expected to be 80% in the month of sale and 20% in the month following the sale. • The cost of goods sold is 69% of sales. • The company desires an ending merchandise inventory equal to 80% of the cost of goods sold in the following month. Payment for merchandise is made in the month following the purchase. • Other monthly expenses to be paid in cash are $20,100. Monthly depreciation is $19,900. Ignore taxes. Balance Sheet October 31 Assets Cash $ 20,900 81,900 Accounts receivable Merchandise inventory 193,200 Property, plant and equipment (net of $585,000 accumulated depreciation) 995,000 Total assets $1,291,000 Liabilities and Stockholders' Equity Accounts payable $ 194,900 500,000 596,100 Common stock Retained earnings Total…