1.Which of the following budgets comes after the production budget but before the cash budget?. Single choice.
A. Sales budget
B. Material purchases budget
C. Budgeted balance sheet
D. Budgeted income statement
2.Which of the following is NOT usually a way to estimate future sales?. Single choice.
A. Trends in the company’s sales data
B. Estimates from the company’s salespersons
C. Sales are estimated based on expected costs
D. Mathematical models adjusted by an experienced manager using professional judgment
3.A company expects to sell 15,000 units in the first quarter, 18,000 units in the second quarter, and 20,000 units in the third quarter. The company desires to maintain an inventory at the end of each quarter equal to 10% of next quarter expected sales. How many units does the company plan to produce in the second quarter?. Single choice.
A. 2,000
B. 20,000
C. 18,150
D. 18,200
In: Accounting
GableGable
Manufacturing produces self-watering planters for use in upscale retail establishments. Sales projections for the first five months of the upcoming year show the estimated unit sales of the planters each month to be as follows:
(Click the icon to view additional information.) Inventory at the start of the year was 900
planters. The desired inventory of planters at the end of each month should be equal to 25%
of the following month's budgeted sales. Each planter requires two
pounds of polypropylene (a type of plastic). The company wants to have 10%
of the polypropylene required for next month's production on
hand at the end of each month. The polypropylene costs $ 0.20 per
pound.Read the requirements
LOADING....
|
1. |
Prepare a production budget for each month in the first quarter of the year, including production in units for each month and for the quarter. |
|
2. |
Prepare a direct materials budget for the polypropylene for each month in the first quarter of the year, including the pounds of polypropylene required and the total cost of the polypropylene to be purchased. |
|
Number of planters to be sold |
|
|
January. . . . . . |
3,600 |
|
February. . . . . |
3,300 |
|
March. . . . . . . . |
3,100 |
|
April. . . . . . . . . |
4,700 |
|
May. . . . . . . . . |
4,900 |
|
Gable Manufacturing |
|||||
|
Production Budget |
|||||
|
For the Months of January through March |
|||||
|
January |
February |
March |
Quarter |
||
|
Unit sales |
3,600 |
3,300 |
3,100 |
10,000 |
|
|
Plus: |
Desired ending inventory |
||||
|
Total needed |
|||||
|
Less: |
Beginning inventory |
||||
|
Units to produce |
|||||
Requirement 2. Prepare a direct materials budget for the polypropylene for each month in the first quarter of the year, including the pounds of polypropylene required and the total cost of the polypropylene to be purchased.
Start by preparing the direct materials budget through the total quantity needed, then complete the budget.
|
Gable Manufacturing |
|||||
|
Direct Materials Budget |
|||||
|
For the Months of January through March |
|||||
|
January |
February |
March |
Quarter |
||
|
Units to be produced |
|||||
|
Multiply by: |
Quantity of direct materials needed per unit |
||||
|
Quantity needed for production |
|||||
|
Plus: |
Desired ending inventory of direct materials |
||||
|
Total quantity needed |
|||||
In: Accounting
Quarterly deposits are made into a fund at the beginning of each quarter starting today for 5 years. The first 8 deposits are $1000 each and deposits increase by 1% per quarter thereafter. If the fund earns 8% effective annually, find the accumulated value at the end of 5 years.
Please explain which equations you used and do not use excel.
In: Finance
in your opinion, should the government cut its spending levels, and if so, what specific area should be cut first? Explain your reasoning. What could be the possible unintended consequences of such a cut?
Attachments
Skills
In: Economics
| Q4Y4 | Q1Y5 | Q2Y5 | Q3Y5 | Q4Y5 | Total | |
| Budgeted Sales (Actual for Q4Y4) | 10000 | 11000 | 14000 | 15000 | 17000 | 57000 |
| Selling Price/per unit | 9 | 9 | 9 | 9 | 9 | 9 |
| Sale Collection | ||||||
| In quarter of sale | 0.8 | |||||
| In following quarter | 0.2 | |||||
| Desired ending finished goods inventory | 2500 | 2200 | 2400 | 2100 | 2100 | |
| Raw Materials/per unit | 5 | 5 | 5 | 5 | 5 | 5 |
| Desired Ending raw material inventory Inventory | 5000 | 8000 | 7000 | 6000 | 5000 | 5000 |
| Raw material price/per unit | 2 | 2 | 2 | 2 | 2 | 2 |
| Accounts payable | ||||||
| In quarter of purchase | 0.7 | |||||
| In following quarter | 0.3 | |||||
| Q4Y4 raw material cost | 100000 |
REQUIRED:
| Sale Budget | Year 5 Quarters | |||||
| 1 | 2 | 3 | 4 |
Year |
||
| Production Budget |
| Material Budget |
|
Cash Receipts |
| Cash Payments |
In: Accounting
*Problem 5-35
Bonita Products, a rapidly growing distributor of home gardening equipment, is formulating its plans for the coming year. Carol Jones, the firm’s marketing director, has completed the following sales forecast.
Month Sales Month Sales
January $904,300 July $1,503,900
February $1,002,600 August $1,503,900
March $904,300 September $1,610,000
April $1,158,500 October $1,610,000
May $1,254,900 November $1,503,900
June $1,405,100 December $1,700,100
Phillip Smith, an accountant in the Planning and Budgeting Department, is responsible for preparing the cash flow projection. He has gathered the following information.
? All sales are made on credit.
? Bonita’s excellent record in accounts receivable collection is expected to continue, with 60% of billings collected in the month after sale and the remaining 40% collected two months after the sale.
? Cost of goods sold, Bonita’s largest expense, is estimated to equal 40% of sales dollars. Seventy percent of inventory is purchased one month prior to sale and 30% during the month of sale. For example, in April, 30% of April cost of goods sold is purchased and 70% of May cost of goods sold is purchased.
? All purchases are made on account. Historically, 75% of accounts payable have been paid during the month of purchase, and the remaining 25% in the month following purchase.
? Hourly wages and fringe benefits, estimated at 30% of the current month’s sales, are paid in the month incurred.
? General and administrative expenses are projected to be $1,560,800 for the year. A breakdown of the expenses follows. All expenditures are paid monthly throughout the year, with the exception of property taxes, which are paid in four equal installments at the end of each quarter.
Salaries and fringe benefits $ 325,500
Advertising 378,900
Property taxes 137,400
Insurance 193,900
Utilities 178,300
Depreciation 346,800
Total $ 1,560,800
? Operating income for the first quarter of the coming year is projected to be $324,300. Bonita is subject to a 40% tax rate. The company pays 100% of its estimated taxes in the month following the end of each quarter.
? Bonita maintains a minimum cash balance of $50,000. If the cash balance is less than $50,000 at the end of the month, the company borrows against its 12% line of credit in order to maintain the balance. All borrowings are made at the beginning of the month, and all repayments are made at the end of the month (in increments of $1,000). Accrued interest is paid in full with each principal repayment. The projected cash balance on April 1 is $59,200.
Warning
Don't show me this message again for the assignment
Ok Cancel
Prepare the cash receipts budget for the second quarter. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.)
Cash Receipts Budget
April May June Total Cash Receipts
February sales $
$
$
$
March sales
April sales
May sales
Totals $
$
$
$
Accounts Receivable balance at the end of second quarter of 2015 $
Warning
Don't show me this message again for the assignment
Ok Cancel
Prepare the purchases budget for the second quarter. (Round answers to 0 decimal places, e.g. 5,275. Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.)
Purchases Budget
April May June Total Purchases
April COGS $
$
$
$
May COGS
June COGS
July COGS
Totals $
$
$
$
Warning
Don't show me this message again for the assignment
Ok Cancel
Prepare the cash payments budget for the second quarter. (Round answers to 0 decimal places, e.g. 5,275. Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.)
Cash Payments Budget
April May June
March purchases $
$
$
April purchases
May purchases
June purchases
$
$
$
Accounts Payable balance at the end of second quarter of 2015 $
Warning
Don't show me this message again for the assignment
Ok Cancel
Prepare the cash budget for the second quarter. (Round answers to 0 decimal places, e.g. 5,275. Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.)
Cash Budget
April May June Quarter
Beginning Cash balance $
$
$
$
Financing:
Ending Cash Balance $
$
$
$
**Need help preparing the cash budget for the next quarter. I'm not sure how to calculate the numbers.
In: Accounting
Can you please provide the workings and how you found each answer?
Jesper Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Jesper Manufacturing's operations:
|
Current Assets as of December 31 (prior year): |
|
|
Cash |
$4,460 |
|
Accounts receivable, net |
$52,000 |
|
Inventory |
$15,400 |
|
Property, plant, and equipment, net |
$122,000 |
|
Accounts payable |
$44,000 |
|
Common stock |
$126,860 |
|
Retained earnings |
$23,000 |
|
January |
$80,100 |
|
February |
$89,100 |
|
March |
$82,800 |
|
April |
$85,500 |
|
May |
$77,400 |
Requirements:
In: Accounting
"Elizabeth Egbert owns a galvanizing plant. Customers bring in their fabricated steel products (like light poles, towers, trailers, etc.), and Egbert dips them into a heated vat of molten zinc. The zinc bonds to the metal and produces a highly durable corrosion resistant product. " Egbert's primary inventory is molten zinc purchased from suppliers in large blocks of solid material. These blocks are immersed in the heated vat and will melt together with the zinc already in the pool. Egbert generally keeps the vat relatively full, and it is never allowed to cool. Egbert started the year 20X8 with 500,000 pounds of zinc in the pool. During the year Egbert purchased 2,800,000 pounds of zinc. At year's end, the pool contained 520,000 pounds of zinc.
Please answer A, C, E, F, G
(a) How much zinc was used during 20X8? (b) Accountants frequently refer to "goods available for sale." Is this concept the same as ending inventory? How much zinc, in pounds, was "available for sale?" (c) If the beginning inventory cost $1.25 per pound, and purchases during 20X8 cost $1.50 per pound, how much is the "cost of goods available for sale"? (e) If Egbert uses FIFO, how much should be attributed to ending inventory and how much to cost of goods sold? (f) If Egbert uses LIFO, how much should be attributed to ending inventory and how much to cost of goods sold? (g) What will be the difference in profitability between choosing the FIFO and LIFO methods? Does is seem reasonable the choice of accounting method can change the reported profit?
In: Accounting
"Mankota Company’s purchasing manager, Fernando Garza, is preparing a purchases budget for the next quarter. At his request, Ruben Carpenter, the manager of the sales department, forwarded him the following preliminary sales budget: Preparing an inventory purchases budget and schedule of cash payments Budgeted sales October $240,000 November $300,000 December $360,000 January$320,00" "For budgeting purposes, Mankota estimates that cost of goods sold is 75 percent of sales. The company desires to maintain an ending inventory balance equal to 20 percent of the next period’s cost of goods sold. The September ending inventory is $40,000. Mankota makes all pur-chases on account and pays 70 percent of accounts payable in the month of purchase and the remaining 30 percent in the following month. The balance of accounts payable at the end of September is $37,500.Required a. Prepare an inventory purchases budget for October, November, and December.b. Determine the amount of ending inventory Mankota will report on the end-of-quarter pro forma balance sheet.c. Prepare a schedule of cash payments for inventory for October, November, and December.d. Determine the balance in accounts payable Mankota will report on the end-of-quarter pro forma "
In: Accounting
1.
A basket of goods and services purchased by an average urban consumer had a cost of $340 in the year 2015, $350 in the year 2016, and $360 in the year 2017. You may assume the base year is 2015.
The inflation rate between 2015 and 2016 was _____ the inflation rate between 2016 and 2017.
Group of answer choices
the same as
lower than
higher than
it is impossible to say from the information given
2.
Bill’s nominal income in 1990 was $38,256 per year. The CPI had a value of 141.67 in 1990 and had a value of 222.33 in 2017. What is Bill’s real income in 1990, measured in 2017 dollars? Enter a number rounded to two decimal places with no dollar sign.
3.
Indicate whether each of the following affect consumption spending (C), investment spending (I), government spending (G), net export spending (NX), or none of the above (N). Enter only the letter given in parenthesis.
Carmax sells a three year old car to John .
The government sends a social security payment to your grandfather .
John spends his social security check on a new computer .
Publix buys 4 new computers .
You pay your tuition to UCF .
4.
The inflation rate between the years 2000 and 2001 was 3.79%. Based on this information, a basket of goods that cost $150 in the year 2000 would now cost how much in the year 2001? Enter a number rounded to two decimal places.
In: Economics