1.The manager of MN Company give you the following data to prepare the required purchases for the coming three months (January, February and March) |
||
Estimated sales for January |
$ 100,000 |
|
Sales increase by |
5% |
for the coming three months |
Cost of goods sold (CGS) |
60% |
of sales |
Beginning inventory |
$ 12,000 |
|
Ending inventory equal to |
20% |
of next month CGS |
Find the total purchases needed for February.
a. |
between $60,000 and $61,000 |
|
b. |
between $63,000 and $64,000 |
|
c. |
between $66,000 and $67,000 |
|
d. |
between $68,000 and $69,000 |
2.
Tany Company has the following data |
|
Account Receivable |
|
December-31-2005 |
$90,000.00 |
January-30-2006 |
$120,000.00 |
Sales during |
|
December 2005 |
x |
January 2006 |
y |
Sales collections |
|
During the month of sales |
40% |
Next month of sales |
60% |
Normally there is no bad debt |
|
Find the sales made during December |
a. |
$150,000.00 |
|
b. |
$225,000.00 |
|
c. |
$200,000.00 |
|
d. |
$300,000.00 |
1.The manager of MN Company give you the following data to prepare the required purchases for...
Zoli Company provided the following information for 2019 Purchases 5,250,000.00 Purchases returns & allowances 150,000.00 Rental Income 250,000.00 Selling Expenses: Freight out 175,000.00 Saleman's Commission 650,000.00 Depreciation - Store Equipment 125,000.00 Merchandise Inventory , January 1,000,000.00 Merchandise Inventory , December 31 1,500,000.00 Sales 7,850,000.00 Sales returns and Allowances 140,000.00 Sales Discounts 10,000.00 Administrative Expenses Officer's Salaries 500,000.00 Depreciation - Office Equipment 300,000.00 Freight in 500,000.00 Income Tax 250,000.00 Loss on Sale...
Zoli Company provided the following information for 2019 Purchases 5,250,000.00 Purchases returns & allowances 150,000.00 Rental Income 250,000.00 Selling Expenses: Freight out 175,000.00 Saleman's Commission 650,000.00 Depreciation - Store Equipment 125,000.00 Merchandise Inventory , January 1,000,000.00 Merchandise Inventory , December 31 1,500,000.00 Sales 7,850,000.00 Sales returns and Allowances 140,000.00 Sales Discounts 10,000.00 Administrative Expenses Officer's Salaries 500,000.00 Depreciation - Office Equipment 300,000.00 Freight in 500,000.00 Income Tax 250,000.00 Loss on Sale...
Purchases Budget in Units and Dollars Budgeted sales of Wirtz Music Shop for the first six months of 2017 are as follows: Month Unit Sales Month Unit Sales January 155,000 April 240,000 February 185,000 May 205,000 March 225,000 June 265,000 Beginning inventory for 2017 is 35,000 units. The budgeted inventory at the end of a month is 40 percent of units to be sold the following month. Purchase price per unit is $5. Prepare a purchases budget in units and...
Preparing a Direct Materials Purchases Budget Patrick Inc. makes industrial solvents sold in 5-gallon drum containers. Planned production in units for the first 3 months of the coming year is: January 45,000 February 50,000 March 60,000 Each drum requires 6 gallons of chemicals and one plastic drum container. Company policy requires that ending inventories of raw materials for each month be 20% of the next month's production needs. That policy was met for the ending inventory of December in the...
Wallace Company provides the following data for next year: January February March April Budgeted Purchases $78,000 70,200 91,000 95,550 Inventory at the end of December is $29,600 and target ending inventory levels are 10% of next month's sales, stated at cost. What is the amount of purchases budgeted for January? O A. $85,020 O B. $55,420 OC. $70,980 OD. $78,000
Problem Solving Completing a Master Budget: The following data relate to the operations of Rebel Corporation, a wholesale distributor of consumer goods. Current assets as of December 31: Cash Accounts receivable Inventory Buildings and equipment Accounts payable Capital Stock Retained earnings 15,000 25,000 18,500 110.000 35.000 100,000 23,500 a. The gross margin is 40% of sales (so cost of goods sold is 60% of sales) b. Actual and budgeted sales data are as follows: Below table indicates sales for December...
A company has budgeted direct materials purchases of $310000 in July and $470000 in August. Past experience indicates that the company pays for 70% of its purchases in the month of purchase and the remaining 30% in the next month. During August, the following items were budgeted: Wages Expense $100000 Purchase of office equipment 67000 Selling and Administrative Expenses 44000 Depreciation Expense 31000 The budgeted cash disbursements for August are $633000. $664000. $589000. $422000. The following credit sales are budgeted...
Ivanhoe Company prepares monthly cash budgets. Relevant data
from operating budgets for 2020 are as follows.
January
February
Sales
$414,000
$460,000
Direct materials purchases
138,000
143,750
Direct labor
103,500
115,000
Manufacturing overhead
80,500
86,250
Selling and administrative expenses
90,850
97,750
All sales are on account. Collections are expected to be 50% in the
month of sale, 30% in the first month following the sale, and 20%
in the second month following the sale. Sixty percent (60%) of
direct materials purchases...
Question 4 (11 marks) The following information pertains to the operating budgets for Casey Corporation. • Budgeted sales: $200,000 in January and $100,000 in February. • All sales are on credit. Collections for sales are 60% in the month of sale and 40% the next month. • Cost of goods sold (COGS) is 75% of sales. • Beginning accounts receivable is $0. • Beginning inventory is $14,000. • Beginning accounts payable is $80,000, of which 10% is related to sales in November the year before, the remainder...
You are given the following budgeted and actual data for the Grey Company for each of the months January through June of the current year. In December of the prior year, sales were forecasted as follows: January, 93 units; February, 88 units; March, 95 units; April, 100 units; May, 107 units; June, 115 units. In January of the current year, sales for the months February through June were reforecasted as follows: February, 83 units; March, 95 units, April, 95 units;...