According to the following information: Description The cost of goods sold 225 million Rials April 1391 250 million Rials 280 million Rials March 1390 May 1391 June 1391 210 million Rials Payment pattern: 35% in the same month, 65% in the following month The rest of the information: • Monthly salary 35 million Rials. • The cost of water and electricity is paid one by one. The first payment in May is 320 thousand Rials. • Rent and insurance costs in the amount of 9.7 million Rials for 6 months in April. • 12.5 million income tax in June • The annual depreciation cost of equipment is 7.5 million Rials. • Equipment worth 50 million was purchased in May, of which 4 million will be paid immediately and the rest in July. • Other operating expenses 2.25 million Rials paid per month. It is desirable to prepare a cash payment budget for April, May and June 1391 separately.

According to the following information: Description The cost of goods sold 225 million Rials April 1391 250 million Rials 280 million Rials March 1390 May 1391 June 1391 210 million Rials Payment pattern: 35% in the same month, 65% in the following month The rest of the information: • Monthly salary 35 million Rials. • The cost of water and electricity is paid one by one. The first payment in May is 320 thousand Rials. • Rent and insurance costs in the amount of 9.7 million Rials for 6 months in April. • 12.5 million income tax in June • The annual depreciation cost of equipment is 7.5 million Rials. • Equipment worth 50 million was purchased in May, of which 4 million will be paid immediately and the rest in July. • Other operating expenses 2.25 million Rials paid per month. It is desirable to prepare a cash payment budget for April, May and June 1391 separately.

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

The cost of product X is 30 percent of its selling price, and the carrying cost is 8 percent of selling price. Accounts are paid on average 60 days after sale. Sales per month average P35,000. What is the investment in accounts receivable? CHOOSE THE ANSWERA. P600.00B. P6,600.00C. P19,000.00D. P16,600.00E. P26,600.00
The cost of product X is 30 percent of its selling price, and the carrying cost is 8 percent of selling price. Accounts are paid on average 60 days after sale. Sales per month average P25,000. What is the investment in accounts receivable? choose the letter of the correct answera. P8,000.00b. P9,000.00c. P19,000.00d. P29,000.00e. P39,000.00
Julekha conversion period of 50 days, an average cullecuion period (DSO) uf 35 lays, and a payables deferral period of 25 days. Assume that cost of goods sold is 80% of Enterprises has an inventory sales. Julekha's annual cost of labour is Tk.550,00N) and annual cost of materials is Tk.750,000. ASsume a year = 360 days. a. What is the length of the firm's cash conversion cycle? b. II annual Sales Negus' Tk.4,380,(00) and all sales are on credit, what is the fim's investment in dCCDunts recrivahle? c. How many times per year does Negus Enterprises turn over its inventory? d. How much working capital linancing does Negus have to ensure to complete the cash convPision cycle are
A saleslady in Fortuna mall receives a monthly salary of Ρhр 12,000.00 рlus 10 % on all sales for the month over Ρhр 25,000.00. At the end of the current month she sold Ρhр 42,856.00. What is the amount of her commission? What is her total gross рay for the month?
Butter cup company distribute a single product. The company's sale's and expenses for last month follow: Sale's P 450,000. Per unit P 30 Variable expenses 180,000 per unit P12 Contribute margin 270,000 per unit P18 Fixed expenses 216,000 Net operating income P54,000 What is the monthly break-even points in unit sold and in sales pesos? How many units would have to be sold each month to earn a target profit of Php 90,000 $ Use the formula method verify your answer by preparing a contribution format income statement at the target sale's level
A merchandiser plans to sell 12,100 units next month at a selling price of $110 per unit. It also gathered the following cost estimates for next month: Cost Cost of goods sold Advertising expense Depreciation expense Shipping expense Administrative salaries Sales commissions Insurance expense Cost Formula $60 per unit sold. $150,000 per month $70,000 per month. $100,000 per month +$10 per unit sold $50,000 per month. 5% of sales $15,000 per month What is the estimated total contribution margin for next month?
During June 1, Company B sold a merchandise for P 1,440,000. The mark up on this kind of sale is at 25% of cost. Company B allocated P 60,000 for trade-in allowance while the balance will be paid in monthly basis within 20 months. The trade-in details are as follows:a. Estimated Selling Price 100,000b. Reconditioning Cost 6,000c. Cost to Sell 4,000d. Gross profit on trade-in 20% Compute for the realized gross profit for the year
Alpha Company makes all its sales on account. Accounts receivable payment experience is as follows: Percent paid in the month of sale 35% Percent paid in the month after the sale 54% Percent paid in the second month after the sale 6% Alpha provided information on sales as follows: Мay $150,000 June $125,000 July $136,000 August (expected) $142,000 How much of May's sales are expected to be uncollectible?
Tokyo Corporation purchases P1,500 in raw material each month to support sales of P2,500 that occur in the following month. In addition, Tokyo Corporation pays wages, rent, and taxes that total P700 each month. What is Tokyo's total monthly cash disbursements? a. P300 b. P4,700 c. P700 d. P2,200 e. P1,000
The following sales and purchases are expected over the Four-month period from December to March Purchases Sales December OMR 30000 OMR 26000 January OMR 25000 OMR 30000 February OMR 24000 OMR 24000 March OMR 26000 OMR 28000 Additional Information: 1. Wages are paid each month of OMR 2000, which are paid in month that they are incurred 2. 30% of the Sales are on credit - and we allow one-month credit period - and 70% of the sales for immediate settlement 3. 40% of the Purchases are on credit - and 1 month credit period - and 60% of the purchases are for immediate settlement 4. The balance of cash as at 1 January was OMR 9000 If the company is preparing a budget from January to March, what will be the Closing balance of cash on March ? Select one: a. OMR 7800 b. OMR 7200 c. OMR 5800
A Mikey's sells $119,500 of its accounts receivable to factors at a 1% discount. The firm’s average collection period is one month. What is the dollar cost of the factoring service? Dollar-cost of the factoring service $_________ per month
The Little Rock Company shows fixed expense of $12150, an M/S ratio of 25%, and a C/M ratio of 30% for one month’s operations. Required: a. The break-even point in rupees b. Actual sales c. Profit for the month