| Spring 2020 Spreadsheet Project | ||||||
| Name: | ||||||
| Lexie's Wool Sweaters | ||||||
| Projected Budgeting Data | ||||||
| Sales & Collections | ||||||
|
October 2020 |
November 2020 |
December 2020 |
January 2021 |
February 2021 |
||
| Sales in Units (Sweaters) | 30,000 | 34,000 | 55,000 | 47,000 | 32,000 | |
| Selling Price per Sweater | $ 100.00 | |||||
| Cash Sales Collected in the Month of Sale | 30% | |||||
| Credit Sales Collected in the Month of Sale | 50% | |||||
| Credit Sales Collected in the Following Month | 20% | |||||
| Ending FG Inventory Requirement | 3% | of next months unit sweater sales | ||||
| Ending FG Inventory, September 30 , 2020 | 1,500 | sweaters | ||||
| Product Input Expenses | ||||||
| Direct Materials | ||||||
| Ending RM Inventory, September 30, 2020 | 8265.60 | yards | ||||
| Yards of Wool Required per Sweater | 4 | yards per sweater | ||||
| Raw Materials Cost per Yard of Wool | $ 3.50 | per yard | ||||
| Ending RM Inventory Requirement | 7% | of next months sweater production needs | ||||
| Wool Purchases Paid for in the Month of Purchase | 85% | |||||
| Wool Purchases Paid for in the Month following the Purchase | 15% | |||||
| Direct Labor | ||||||
| Number of Workers Required for the Making of Each Sweater | 5 | workers | ||||
| Labor Hours Required per Worker per Unit of FG (Sweater) | 0.5 | hours | ||||
| Labor Cost per Hour | $ 15.00 | per hour | ||||
| Manufacturing Overhead | ||||||
| Variable Manufacturing Overhead | $ 11.75 | per sweater | ||||
| Fixed Manufacturing Overhead | $ 30,200.00 | per month (Oct.) | $ 30,750.00 | per month (Nov. & beyond) | ||
| Noncash Fixed Manufacturing Overhead (included in above) | $ 10,250.00 | per month (Oct.) | $ 15,750.00 | per month (Nov. & beyond) | ||
| Selling & Administrative Expenses | ||||||
| Variable S&A | $ 7.37 | per unit sold | ||||
| Fixed S&A | $ 23,900.00 | per month | ||||
| Noncash Fixed S&A (included in above) | $ (10,750.00) | per month | ||||
| Factory Update & Cash Flow | ||||||
| Factory Update (PP&E) | $ 400,500.00 | paid on October 31, 2020 | ||||
| Principle Borrowed on October 1, 2020 | $ 300,000.00 | |||||
| Principle Repaid on November 30, 2020 | $ 300,000.00 | |||||
| Interest Payment on Borrowings in October & November | $ 9,000.00 | per month (paid in following month) | ||||
Create a Direct Labor Budget in Excel using Formulas only
In: Accounting
N =
I =
PV =
PMT =
FV =
P/Y =
In: Finance
In 2015, Yum! Brands, Inc., the world’s largest quick-service restaurant company (Pizza Hut, Kentucky Fried Chicken, and Taco Bell), opened 577 new Pizza Hut restaurants and closed 456 others.
Required
If you were in charge of these decisions, what information would you want to collect?
In: Accounting
A cylindrical tube of mean radius 1” and wall thickness 0.1” is subjected to an internal pressure p = 300 psi and a torque T = 2000 lb-in. The ends of the tube are closed. Find the safety factor against yielding if the material yields in uniaxial tension at SY = 8 ksi and Von Mises theory is used.
In: Mechanical Engineering
A mole of air is sampled from the atmosphere when the atmospheric pressure is 765 mmHg, the temperature is 25 C, an relative humidity is 75%. The sample of air is placed inside a closed container and heated to 135 C and then compressed to 2 atm. What are the relative humidity, the humidity, and the mole fraction of water in the compressed air?
In: Chemistry
A project will produce cash inflows of $1,750 a year for four years. The project initially costs $10,600 to get started. In year five, the project will be closed and as a result should produce a cash inflow of $8,500. What is the net present value of this project if the required rate of return is 14.75%?
|
-$1,306.18 |
||
|
-$935.56 |
||
|
$5,474.76 |
||
|
$1,011.40 |
In: Finance
Think about what would happen if you didn't close the accounts at the end of the accounting period. Using no less than 100 words, explain what accounting principles or concepts would be violated if the accounts were not closed at the end of one accounting period when this had been done in previous years.
In: Accounting
Let F(x,y,z) = < z tan-1(y2), z3 ln(x2 + 1), z >. Find the flux of F across S, the top part of the paraboloid x2 + y2 + z = 2 that lies above the plane z = 1 and is oriented upward. Note that S is not a closed surface.
In: Math
For 300 trading days, the daily closing price of a stock (in $) is well modeled by a Normal model with a mean of
$197.12197.12 and a standard deviation of
$7.187.18. According to this model, what is the probability that on a randomly selected day in this period, the stock price closed as follows.
a) above $204.30204.30?
b) below $211.48211.48?
c) between $182.76182.76 and $211.48211.48?
In: Math
XYZ used an investment bank to do IPO. In IPO, XYZ sold 1 million shares at $68 each. The investment bank charged 7% spread. At the end of the 1st day of trading, XYZ stock price closed at $80. Calculate the total cost of IPO. That is, what is the sum of direct and indirect cost?
In: Finance