Question Completion Status:Forecast SalesJanFebMar$200 000$160.000$180,000$45,000AprBalance Sheet DataDecember 31,2010Cash$80,000Account receivable:November sales45000December sales50000InventoryAccount payable(merchandise)5400027000Other data are as follows:• Sales are on credit with 60% of sales collected in the same month after sale 40% in the second month after sale• Cost of goods sold is 50% of sales• Other variables costs are 30% of sales paid in the month incurred• Inventories are to be 80% of next month's budgeted sales requirements• Fixed expenses are $15000 per month; all require cash• Credit time period for purchases are 30 daysOn basis of above information answer following questionsFind Net Profit for the ended of March 2011?^ @ d ENG

The budget indicates the forecasting made by the management after analyzing the past performances…

Forecast Sales $200,000 $160,000 $180,000 $45,000 Jan Feb Mar Apr Balance Sheet Data December 31,2010 Cash $80,000 Account receivable: November sales 45000 December sales 50000 Inventory Account payable(merchandise) 54000 27000 Other data are as follows: • Sales • Cost of goods sold is 50% of sales • Other variables costs are 30% of sales paid in the month incurred • Inventories are to be 80% of next month's budgeted sales requirements • Fixed expenses are $15000 per month; all require cash • Credit time period for purchases are 30 days on credit with 60% of sales collected in the same month after sale ,40% in the second month after sale On basis of above information answer following questions Find Net Profit for the ended of March 2011?

Forecast Sales $200,000 $160,000 $180,000 $45,000 Jan Feb Mar Apr Balance Sheet Data December 31,2010 Cash $80,000 Account receivable: November sales 45000 December sales 50000 Inventory Account payable(merchandise) 54000 27000 Other data are as follows: • Sales • Cost of goods sold is 50% of sales • Other variables costs are 30% of sales paid in the month incurred • Inventories are to be 80% of next month's budgeted sales requirements • Fixed expenses are $15000 per month; all require cash • Credit time period for purchases are 30 days on credit with 60% of sales collected in the same month after sale ,40% in the second month after sale On basis of above information answer following questions Find Net Profit for the ended of March 2011?

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter22: Master Budget (master)

Section: Chapter Questions

Problem 1R: Ranger Industries has provided the following information at June 30: Other information: Average...

See similar textbooks

Similar questions

Ranger Industries has provided the following information at June 30: Other information: Average selling price, 196 Average purchase price per unit, 110 Desired ending inventory, 40% of next months unit sales Collections from customers: In month of sale20% In month after sale50% Two months after sale30% Projected cash payments: Inventory purchases are paid for in the month following acquisition. Variable cash expenses, other than inventory, are equal to 25% of each months sales and are paid in the month of sale. Fixed cash expenses are 40,000 per month and are paid in the month incurred. Depreciation on equipment is 2,000 per month. REQUIREMENT You have been asked to prepare a master budget for the upcoming quarter (July, August, and September). The components of this budget are a monthly sales budget, a monthly purchases budget, a monthly cash budget, a forecasted income statement for the quarter, and a forecasted September 30 balance sheet. The worksheet MASTER has been provided to assist you. Ranger Industries desires to maintain a minimum cash balance of 8,000 at the end of each month. If this goal cannot be met, the company borrows the exact amount needed to reach its goal. If the company has a cash balance greater than 8,000 and also has loans payable outstanding, the amount in excess of 8,000 is paid to the bank. Annual interest of 18% is paid on a monthly basis on the outstanding balance.
63. Summarized below are the Receipts ad Payments forecasts for the months of July to December 2010 Purchases Wages 4,000 Selling Exp. Months Sales Misc. Exp. 30,000 32,000 4,000 5,000 8,000 July August September 16,000 18,000 15,000 2,000 7,000 34,000 30,000 26,000 30,000 3,000 17,000 18,000 16,000 3,000 2,000 4,000 4,000 3,000 4,000 3,000 9,000 6,000 8,000 9,000 October November December You are given the following further information: 1. Machinery costing Rs. 20,000 is due for delivery in Dec. payable 10% on delivery and balance after three months. 2. Advance income tax in Nov. Rs. 3,000. 3. Period of credit allowed: (i) By suppliers 2 months and (ii) To customers 1 month. 4. Lag of payments of wages – 12 month. 5. Lag of payment of selling expenses 1 month. You are required to prepare a cash budget for four months starting on 1 September 2010 when there was cash balance of Rs. 10,000.
The following information is available from the accounting records of Waxford Ltd.: 19-- January February March April Purchases R42 000 48 000 54 000 36 000 Purchases Total sales Administrative expenses Total sales R72 000 66 000 Twenty percent of sales are expected to be for cash. Collections from customers are normally 70% in the month of sale, 20% in the month following the month of sale, and 9% in the second month following the month of sale. Customers paying in the month of sale get a 5% discount. 78 000 60 000 The corporation pays its creditors in the month following the month of purchase, and qualifies for a 5% discount on all its purchases. Budgeted information for the months of May and June is as follows: May R45 000 72 000 14 500 June R42 000 70 000 16 600 Administrative expenses, which include depreciation of R600 per month, are payable in the month incurred. Rates for the year, amounting to R1 500, are included in the administrative expenses for June. The balance per cash…
The following accounting records reveal: A/R, beg. P100,000 Iny, beg. P50,000 Purchases P90,000 Purchases Discount P5,000 Collections P200,000 How much is the vatable sales? a. P250,000 b. P240,000 How much is the output vat? a. P27, 600 b. P28,800 A/R, end Iny, end Sales Sales Return Cost of Sales. c. P230,000 c. P30,000 P110, 000 P60,000 P250,000 P10,000 P70,000 d. P24,000 d. P200,000
Sales Forecast using Weighted Moving Average 1. Given the following, determine the expected sales on September 18th and September 19th, using a 3-day weighted moving average. 2. Is your weighted moving average result higher or lower than if you had simply done a 3-day moving average? What caused it to be higher or lower? MONTH DATE ACTUAL SALES IN DOLLARS W1 = 10 W2 = 25 W3 = 30 SEPTEMBER 12 13 14 15 16 17 18 19 $1,500 $2,500 $2.500 $3,500 $3.000 $4,500
owe
From the following information regarding the year to 31 August 20X6, what is the payables' payment period? $ Sales 43,000 Cost of sales 32,500 Opening inventory 6,000 Closing inventory 3,800 Payables at 31 August 20X6 4,750 A 40 days B 50 days C 53 days D 57 days
A seller of goods had the following data during the month.Total Sales Invoice (billed price) Php 224,000Gross receipts, including VAT 201,600Sales returns and allowances, billed price 11,200Input VAT 12,000 How much is the VAT payable?
! Required information Use the following information for the Quick Studies below. (Algo) ($ thousands) Net sales Current Year $ 803,470 394,775 Prior Year $ 455,095 135,878 Cost of goods sold QS 17-7 (Algo) Trend percents LO P1 Determine the Prior Year and Current Year trend percents for net sales using the Prior Year as the base year. (Enter the answers in thousands of dollars.) Current Year: Prior Year: Numerator: Trend Percent for Net Sales: 1 1 1 1 Denominator: = = = Trend Percent 0 % 0 %
Aston Company reported the following balances at September 30, 2020:Sales Revenue $280,000Sales Returns and Allowances 13,000Sales Discounts 5,000Cost of Goods Sold 160,500Calculate the Net sales for the month.
You are given the following information relating to Suns Trading: Gross profit rate based on sales 25%Accounts Receivable, December 31, 2022 P120,000Collections on accounts receivable during 2023 545,000Cost of goods available for sale during 2023 690,000Merchandise Inventory, December 31, 2023 150,000 Of the total sales during the year, eighty percent (80%) were made on account. Question:22. What was the company's Accounts Receivable balance at December 31, 2023? A. P115,000 B. P151,000 C. P159,000 D. P295,000
Use the following information for the Quick Studies below. (Algo) ($ thousands) Net sales Current Year $ 802,213 393,339 Prior Year $ 453,350 134,505 Cost of goods sold QS 13-7 (Algo) Trend percents LO P1 Determine the Prior Year and Current Year trend percents for net sales using the Prior Year as the base year. (Enter the answers in thousands of dollars.) Current Year: Prior Year: Numerator: Trend Percent for Net Sales: 1 1 1 Denominator: = = = Trend Percent 0% 0 %