1. entertainment
2. windows media player
instruction for a computer to follow
Answer:
program/software program
Explanation:
main types are application software and system software
Given the following Java code:
public static boolean f(int [] arr) {
for (int i = 0; i < arr.length - 1; i++) {
for (int j = i + 1; j < arr.length; j++) {
if (arr[i] < arr[j]) // *HERE*
return false;}
return true;}
(i) Find the number of times the comparison marked by *HERE* will be evaluated for each input:
{1, 2}
{10, 20, 30}
{30, 20, 10}
{-4, 7, 1}
(ii) For an array of size ????, what is the big-oh runtime of this code in the worst case?
Answer:
See explaination
Explanation:
{1, 2}
Runs only once for 1 < 2
{10, 20, 30}
Runs 1 for 10 < 20
Runs 1 for 10 < 30
Runs 1 for 20 < 30
Total 3 times
{30, 20, 10}
Runs 1 for 30 < 20
Runs 1 for 30 < 10
Runs 1 for 20 < 10
Total 3 times
{-4, 7, 1}
Runs 1 for -4 < 7
Runs 1 for -4 < 1
Runs 1 for -7 < 1
Total 3 times
Generalizing it will run for n*(n-1)/2 so for 2 element it will run for 2*1/2 = 1
For 3 element it will run for 3*2/2 = 3 times
(ii) (3 points) For an array of size , what is the big-oh runtime of this code in the worst case?
Time complexity in Worst case is O(n^2). Reason being it uses two for loop where first loop runs for n time and the second loop runs for n*n time in worst case hence its O(n^2)
Fill in the blanks in the SQL statement below that will list the invoice number, invoice total and credit which is the total sum of the payment_total and credit_total. Format the payment credit to 2 decimal places. SELECT invoice_number, invoice_total________ AS credit FROM invoices.
Answer:
Following are the query and its explanation:
Explanation:
SELECT invoice_number , invoice_total , FORMAT ((payment_total +credit_total),2) AS Credit FROM invoices;
In the above given select command it selects two columns that are "invoice_number , invoice_total" in which it uses the format method that adds "payment_total and credit_total" parameter value and divides the value, and holds its decimal point value use by the invoices table.
why do you think social responsibility should be consider in the business environment
Businesses that embrace social responsibility initiatives can increase consumer retention and loyalty. Social responsibility programmes can improve employee morale at work and result in increased productivity.
What does corporate social responsibility entail?The practise of people and organisations acting morally and conducting business while being aware of social, cultural, economic, and environmental concerns is known as corporate social responsibility (CSR), also known as social responsibility in business.
Why is it crucial to practise social and environmental responsibility?Our world cannot be used and abused indefinitely without any thought for its future. Every sort of business must urgently take environmental responsibility extremely seriously in order to preserve our environment for future generations.
To know more about generations visit:-
https://brainly.com/question/30719841
#SPJ1
(Print distinct numbers) Write a program that reads in numbers
separated by a space in one line and displays distinct numbers (i.e., if
a number appears multiple times, it is displayed only once). (Hint:
Read all the numbers and store them in list1. Create a new list list2.
Add a number in list1 to list2. If the number is already in the list,
ignore it.)
I've included my code in the picture below.
1. State three modules in HansaWorld and briefly describe what each is used for. (6)
2. With an example, explain what settings are used for. (3)
3. What is Personal Desktop and why is it good to use? Mention two ways in which an
entry can be deleted from the personal desktop. (6)
Describe how you invalidate a record in HansaWorld (3)
Briefly explain what specification, paste special and report windows are used for. (6)
How many reports can you have on the screen at once? How many reports does
HansaWorld have? (4)
4.
5.
6.
7.
8.
9.
Describe any two views of the Calendar and how you can open them (4)
Describe three (3) ways in which records can be attached to Mails. (6)
Describe the basic SALES PROCESS where there is no stock involved and how the
same is implemented in HansaWorld. (12)
Demonstrate competence in a range of skills in Excel including charting and use of functions Select appropriate techniques to explore and summarise a given dataset Highlight and communicate results to the relevant audienc
Answer:
I cannot answer this question as "audienc" isn't a valid word. Please re-write the question (show below):
Demonstrate competence in a range of skills in Excel including charting and use of functions Select appropriate techniques to explore and summarise a given dataset Highlight and communicate results to the relevant audienc
OK OK OK IM KIDDING HERE'S YOUR SOLUTION
Real Answer:
To demonstrate competence in a range of skills in Excel, one should have a strong understanding of the basic and advanced features of Excel, including charting, use of functions, and data analysis tools. This can be achieved through taking online courses, attending workshops, or practicing on their own.
To select appropriate techniques to explore and summarise a given dataset, one should first understand the nature and characteristics of the data, such as its size, format, and complexity. From there, one can choose appropriate Excel functions and tools to organize and analyze the data, such as filtering, sorting, grouping, and pivot tables.
To highlight and communicate results to the relevant audience, one should use appropriate charts and graphs to visually represent the data, as well as create clear and concise summaries and explanations of the results. This requires a strong understanding of the data, as well as the ability to communicate complex information in a clear and understandable manner. Additionally, one should consider the intended audience and their level of expertise when presenting the results, and adjust the presentation accordingly.
Hope it helps!!
In cell F5, enter a formula using the PMT function. Insert a negative sign (-) after the equal sign in the formula to display the result as a positive amount. Use defined names for the rate, nper, and pv arguments as follows:
· rate argument: Divide the Rate by 12 to use the monthly interest rate.
· nper argument: Multiply the Term by 12 to specify the number of months as the periods.
· pv argument: Use the Loan_Amount as the present value of the loan.
2.In cell F6, enter a formula without using a function that multiplies 12 by the Term and the Monthly_Payment, and then subtracts the Loan_Amount to determine the total interest
3. in cell J5, enter another formula using the PV function. Use defined cell names for the rate, nper, and pmt arguments as follows:
· rate argument: Divide the Rate by 12 to use the monthly interest rate.
· nper argument: Subtract the year value in cell H5 from the Term, and then multiply the result by 12 to specify the number of months remaining to pay off the loan.
· pmt argument: Use the Monthly_Payment as a negative value to specify the payment amount per period.
Answer:
Open MS-Office Excel (a.) Define name for rate, nper and pv cells as Rate, Term and Loan_Payment. Select the cell then Menu > Formulas
Word, word, word and word are examples of different _____.
effects
styles
texts
fonts
Answer:
Fonts
Explanation:
edge 2021
As you know computer system stores all types of data as stream of binary digits (0 and 1). This also includes the numbers having fractional values, where placement of radix point is also incorporated along with the binary representation of the value. There are different approaches available in the literature to store the numbers having fractional part. One such method, called Floating-point notation is discussed in your week 03 lessons. The floating point representation need to incorporate three things:
• Sign
• Mantissa
• Exponent
A. Encode the (negative) decimal fraction -9/2 to binary using the 8-bit floating-
point notation.
B. Determine the smallest (lowest) negative value which can be
incorporated/represented using the 8-bit floating point notation.
C. Determine the largest (highest) positive value which can be
incorporated/represented using the 8- bit floating point notation.
Answer:
A. Encode the (negative) decimal fraction -9/2 to binary using the 8-bit floating-point notation.
First, let's convert -9/2 to a decimal number: -9/2 = -4.5
Now, let's encode -4.5 using the 8-bit floating-point notation. We'll use the following format for 8-bit floating-point representation:
1 bit for the sign (S), 3 bits for the exponent (E), and 4 bits for the mantissa (M): SEEE MMMM
Sign bit: Since the number is negative, the sign bit is 1: 1
Mantissa and exponent: Convert -4.5 into binary and normalize it:
-4.5 in binary is -100.1. Normalize it to get the mantissa and exponent: -1.001 * 2^2
Mantissa (M): 001 (ignoring the leading 1 and taking the next 4 bits)
Exponent (E): To store the exponent (2) in 3 bits with a bias of 3, add the bias to the exponent: 2 + 3 = 5. Now, convert 5 to binary: 101
Now, put the sign, exponent, and mantissa together: 1101 0010
So, the 8-bit floating-point representation of -9/2 (-4.5) is 1101 0010.
B. Determine the smallest (lowest) negative value which can be incorporated/represented using the 8-bit floating-point notation.
To get the smallest negative value, we'll set the sign bit to 1 (negative), use the smallest possible exponent (excluding subnormal numbers), and the smallest mantissa:
Sign bit: 1
Exponent: Smallest exponent is 001 (biased by 3, so the actual exponent is -2)
Mantissa: Smallest mantissa is 0000
The 8-bit representation is 1001 0000. Converting this to decimal:
-1 * 2^{-2} * 1.0000 which is -0.25.
The smallest (lowest) negative value that can be represented using the 8-bit floating-point notation is -0.25.
C. Determine the largest (highest) positive value which can be incorporated/represented using the 8-bit floating-point notation.
To get the largest positive value, we'll set the sign bit to 0 (positive), use the largest possible exponent (excluding infinity), and the largest mantissa:
Sign bit: 0
Exponent: Largest exponent is 110 (biased by 3, so the actual exponent is 3)
Mantissa: Largest mantissa is 1111
The 8-bit representation is 0110 1111. Converting this to decimal:
1 * 2^3 * 1.1111 which is approximately 1 * 8 * 1.9375 = 15.5.
The largest (highest) positive value that can be represented using the 8-bit floating-point notation is 15.5.
Explanation:
What study skill is being used when taking a large project and breaking it down into smaller manageable tasks?
Answer:
prioritization
Explanation:
this is the answer
In software terms, a(n)
is a failure or flaw in a computer system that causes an undesired or incorrect outcome.
In the context of software, a "bug" is a malfunction or weakness in a computer system that results in an undesirable or inaccurate result. Several things, including coding errors, poor design decisions.
What is the name for a computer program flaw or error?An error, flaw, or weakness in any computer program or hardware system is what Techopedia refers to as a bug. A bug causes an unexpected system behavior or unexpected results.
What does "software testing failure" mean?A software system or component fails when it is unable to carry out its intended functions within the allotted time frame. A flaw is referred to be a when it reaches the final consumer.
To know more about software visit:-
https://brainly.com/question/1022352
#SPJ1
1. Design a DC power supply for the Fan which have a rating of 12V/1A
To design a DC power supply for a fan with a rating of 12V/1A, you would need to follow these steps:
1. Determine the power requirements: The fan has a rating of 12V/1A, which means it requires a voltage of 12V and a current of 1A to operate.
2. Choose a transformer: Start by selecting a transformer that can provide the desired output voltage of 12V. Look for a transformer with a suitable secondary voltage rating of 12V.
3. Select a rectifier: To convert the AC voltage from the transformer to DC voltage, you need a rectifier. A commonly used rectifier is a bridge rectifier, which converts AC to pulsating DC.
4. Add a smoothing capacitor: Connect a smoothing capacitor across the output of the rectifier to reduce the ripple voltage and obtain a more stable DC output.
5. Regulate the voltage: If necessary, add a voltage regulator to ensure a constant output voltage of 12V. A popular choice is a linear voltage regulator such as the LM7812, which regulates the voltage to a fixed 12V.
6. Include current limiting: To prevent excessive current draw and protect the fan, you can add a current-limiting circuit using a resistor or a current-limiting IC.
7. Assemble the circuit: Connect the transformer, rectifier, smoothing capacitor, voltage regulator, and current-limiting circuitry according to the chosen design.
8. Test and troubleshoot: Once the circuit is assembled, test it with appropriate load conditions to ensure it provides a stable 12V output at 1A. Troubleshoot any issues that may arise during testing.
Note: It is essential to consider safety precautions when designing and building a power supply. Ensure proper insulation, grounding, and protection against short circuits or overloads.
For more such answers on design
https://brainly.com/question/29989001
#SPJ8
A stakeholder is upset that a project is weeks behind schedule and confronts the project manager to ask whether the project should be canceled. according to the acronym niece, what should the pm do?
The project manager can effectively manage the upset stakeholder's concerns and ensure that the project is able to move forward in a productive and collaborative manner.
In this scenario, the project manager should use the acronym NIECE to handle the upset stakeholder.
N - Nod: The project manager should acknowledge the stakeholder's concerns and show understanding of their frustration.
I - Identify: The project manager should identify the specific issues causing the delay and explain the steps being taken to address them.
E - Explore: The project manager should explore potential solutions with the stakeholder, including alternative options and potential trade-offs.
C - Confirm: The project manager should confirm the stakeholder's understanding of the situation and the proposed solutions, ensuring that they are satisfied with the plan moving forward.
E - Execute: Finally, the project manager should execute the plan and keep the stakeholder informed of progress along the way.
Overall, by following the NIECE approach, the project manager can effectively manage the upset stakeholder's concerns and ensure that the project is able to move forward in a productive and collaborative manner. It's important for the project manager to remain calm, communicate clearly, and work collaboratively with all stakeholders to ensure project success.
For more such questions on manage, click on:
https://brainly.com/question/1276995
#SPJ11
What Should be the first step when troubleshooting
The first step in troubleshooting is to identify and define the problem. This involves gathering information about the issue, understanding its symptoms, and determining its scope and impact.
By clearly defining the problem, you can focus your troubleshooting efforts and develop an effective plan to resolve it.
To begin, gather as much information as possible about the problem. This may involve talking to the person experiencing the issue, observing the behavior firsthand, or reviewing any error messages or logs associated with the problem. Ask questions to clarify the symptoms, when they started, and any recent changes or events that may be related.Next, analyze the gathered information to gain a better understanding of the problem. Look for patterns, commonalities, or any specific conditions that trigger the issue. This analysis will help you narrow down the potential causes and determine the appropriate troubleshooting steps to take.By accurately identifying and defining the problem, you lay a solid foundation for the troubleshooting process, enabling you to effectively address the root cause and find a resolution.
For more questions on troubleshooting
https://brainly.com/question/29736842
#SPJ8
One advantage of the Second generation of programming language is that it is machine dependent. True or False
Answer:
I THINK FALSE
Explanation:
A coach wants to divide the basketball team into two groups for a practice game. Which statistical measurement is the coach most likely to use?
A) percentile
B) mean
C) median
D) mode
Answer:
median
Explanation:
Answer:
C) Median
Explanation:
We would like the set of points given in the following figure into 1D space. The set of points has been
generated using this instruction [X, y = make_moons(n_samples = 100)], where X are the 2D features
and y are the labels(blue or red).
How to do that while keeping separable data point with linear classification? Give the
mathematics and the full algorithm.
How to apply the SVM algorithm on this data without dimension reduction? Give the
mathematics and full algorithm.
One way to project the 2D data points onto a 1D space while preserving linear separability is through the use of a linear discriminant analysis (LDA) technique. LDA finds the linear combination of the original features that maximizes the separation between the different classes.
What is the mathematics in SVM algorithm?The mathematics behind LDA involve finding the eigenvectors of the within-class scatter matrix and the between-class scatter matrix and selecting the eigenvector that corresponds to the largest eigenvalue. The full algorithm for LDA can be outlined as follows:
Compute the mean vectors for each class
Compute the within-class scatter matrix (SW) and the between-class scatter matrix (SB)Compute the eigenvectors and eigenvalues of the matrix (SW⁻¹SB)Select the eigenvector that corresponds to the largest eigenvalue as the linear discriminantProject the original data onto the new 1D space using the linear discriminantRegarding the SVM algorithm, it can be applied directly to the original 2D data without the need for dimension reduction. The mathematics behind SVM involve finding the hyperplane that maximizes the margin, or the distance between the closest data points of each class, while also ensuring that the data points are correctly classified.
The full algorithm for SVM can be outlined as follows:
Select a kernel function (e.g. linear, polynomial, radial basis function)Train the model by solving the optimization problem that maximizes the marginUse the trained model to classify new data points by finding the hyperplane that separates the different classesIt is important to note that, in case of non-linearly separable data, SVM algorithm uses the kernel trick to map the original data into a higher dimensional space, where the data is linearly separable.Learn more about algorithm from
https://brainly.com/question/24953880
#SPJ1
Write a program that calculates the cost of an auto insurance policy. The program prompts the user to enter the age of the driver and the number of accidents the driver has been involved in. The program should adhere to these additional requirements:
- If the driver has more than 2 accidents and is less than the age of 25, deny insurance and in lieu of policy amount, print message: Insurance Denied.
- If the driver has more than 3 accidents, deny insurance and in lieu of policy amount, print message: Insurance Denied.
- Include a base charge of $500 dollars for all drivers
- If a driver has 3 accidents, include a surcharge of $600
- If a driver has 2 accidents, include a surcharge of $400
- If a driver has 1 accident, include a surcharge of $200
- If a driver is less than the age of 25, include an age fee of $100
- The total of the policy amount should include the base, any surcharge, and any age fee
- Use a Boolean variable for the purpose of indicating a driver is insurable
- Use at least one logical operator
- Use at least one if - elif block
- Outputs should display currency format with $ signs and commas for thousands
Here's a Python program that calculates the cost of an auto insurance policy based on the age of the driver and the number of accidents they've been involved in.
# Program to calculate auto insurance policy cost
# Prompt user for driver's age and number of accidents
age = int(input("Enter driver's age: "))
accidents = int(input("Enter the number of accidents the driver has been involved in: "))
# Initialize base charge and insurable variable
base_charge = 500
insurable = True
# Check conditions for denying insurance
if accidents > 2 and age < 25:
insurable = False
print("Insurance Denied")
elif accidents > 3:
insurable = False
print("Insurance Denied")
# Calculate surcharge based on the number of accidents
if accidents == 3:
surcharge = 600
elif accidents == 2:
surcharge = 400
elif accidents == 1:
surcharge = 200
else:
surcharge = 0
# Calculate age fee if driver is less than 25 years old
if age < 25:
age_fee = 100
else:
age_fee = 0
# Calculate total policy amount
policy_amount = base_charge + surcharge + age_fee
# Display the policy amount in currency format
print("Policy Amount: ${:,.2f}".format(policy_amount))
This program prompts the user to enter the driver's age and the number of accidents they've been involved in. It then checks the conditions for denying insurance based on the number of accidents and the driver's age. If the driver is insurable, it calculates the surcharge and age fee based on the number of accidents and age.
The total policy amount is calculated by adding the base charge, surcharge, and age fee. Finally, the program displays the policy amount in currency format with dollar signs and commas for thousands. The program uses logical operators (such as and), if-elif blocks, and a boolean variable (insurable) to meet the requirements.
For more question on Python visit:
https://brainly.com/question/26497128
#SPJ8
2. The Internet could best be described as: *
10 points
WWW
A large spider web
A series of roads and highways
A never ending tunnel
Answer:
Explanation:
All options are correct.
Tatiana's friend shared a video with her through email. Tatiana has a hearing impairment. To help understand what's said in the video, Tatiana can use
Since Tatiana has a hearing impairment. To help understand what's said in the video, Tatiana can use the vibrations made by musical sounds.
Can those who have hearing loss appreciate music?Those who have hearing loss can still appreciate music in a similar way to before if they collaborate with their certified audiologist to choose the best course of action.
IDEA defines ring impairment as "a hearing impairment, whether permanent or variable, that adversely impacts a child's academic achievement."
Although they may not be able to hear, d/Deaf persons can use the vibrations created by musical sounds to help them "listen" to music. Musicians with hearing loss frequently use the vibration of their instrument, or the surface to which it is linked, to help them feel the sound that they create.
Lean more about hearing impairment from
https://brainly.com/question/24900023
#SPJ1
you have used firewalls to create a demilitarized zone. you have a web server that needs to be accessible to internet users. the web server must communicate with a database server for retrieving product, customer, and order information. how should you place devices on the network to best protect the servers? (select two.)
Answer:
1. Put the database server on the private network.
2. Put the web server inside the DMZ.
kind regards
Write a program in which will use some of the built-in METHODS as it relates to the use of Strings. 1) The program will ask the user the following prompts: Please enter your first name and their last name, separated by a space. This program will then read-in the user's response using Scanner. You must separate the string input entered by the user into two strings via substrings. Substring one will store the first name and Substring two will store the last name respectively. ***hint this can be accomplish using the indexOf() to find the position of the space. Your program must display/output the number of characters in each name, as well as the user's initials that was entered. You must check and trim all extra white spaces before and after the string entered by the user. Incorporate and loop to have this program ask this user if they would like to execute the program again by prompting and requesting a Y for Yes and a N for No. This prompt should ignore upper or lower case entries. The initials are the first letter of the first name together with the first letter of the last name. Hello their Louis I have your first name as Louis, which has 5 characters Hello again Louis I have your last name as Henry, which has 5 characters Did you know that your initials are LH Do you wish to continue (Y)Yes or (N)No
Answer:
The program in Java is as follows:
import java.util.*;
public class Main{
public static void main(String[] args) {
Scanner input = new Scanner(System.in);
char cont = 'Y';
while(cont == 'Y'){
System.out.print("Name: ");
String name =input.nextLine();
String names [] = name.split(" ");
names[0] = names[0].replaceAll("\\s", "");
names[1] = names[1].replaceAll("\\s", "");
System.out.println("Hello their "+names[0]+", I have your first name as "+names[0]+", which has "+names[0].length()+" characters ");
System.out.println("Hello again "+names[0]+", I have your last name as "+names[1]+", which has "+names[1].length()+" characters ");
System.out.println("Did you know that your initials are "+names[0].charAt(0)+names[1].charAt(0));
System.out.print("Continue (Y)Yes or (N)No: ");
cont = Character.toUpperCase(input.next().charAt(0));
input.nextLine();} }}
Explanation:
This initializes a character variable cont to Y
char cont = 'Y';
This is repeated as long as cont is Y
while(cont == 'Y'){
This prompts the user for name
System.out.print("Name: ");
This gets the name from the user
String name =input.nextLine();
This splits the name into the array of two elements (first name and last name)
String names [] = name.split(" ");
This remove all whitespace from the first name
names[0] = names[0].replaceAll("\\s", "");
This remove all whitespace from the last name
names[1] = names[1].replaceAll("\\s", "");
This prints the details of the first name
System.out.println("Hello their "+names[0]+", I have your first name as "+names[0]+", which has "+names[0].length()+" characters ");
This prints the details of the last name
System.out.println("Hello again "+names[0]+", I have your last name as "+names[1]+", which has "+names[1].length()+" characters ");
This prints the initials
System.out.println("Did you know that your initials are "+names[0].charAt(0)+names[1].charAt(0));
This prompts the user to continue or not
System.out.print("Continue (Y)Yes or (N)No: ");
This gets the user response
cont = Character.toUpperCase(input.next().charAt(0));
input.nextLine();} }
LIST THE BEST 10 CAMERAS FOR FILMING 2022.
1. Fujifilm X-T4
2. Blackmagic Pocket Cinema Camera 6K
3. Nikon Z6 II
4. Sony a7S III
5. Panasonic Lumix S1H
6. Canon EOS R5
7. Sony Alpha 1
8. Blackmagic URSA Mini Pro 12K
9. Canon C300 Mark III
10. ARRI ALEXA Mini LF
xamine the following output:
Reply from 64.78.193.84: bytes=32 time=86ms TTL=115
Reply from 64.78.193.84: bytes=32 time=43ms TTL=115
Reply from 64.78.193.84: bytes=32 time=44ms TTL=115
Reply from 64.78.193.84: bytes=32 time=47ms TTL=115
Reply from 64.78.193.84: bytes=32 time=44ms TTL=115
Reply from 64.78.193.84: bytes=32 time=44ms TTL=115
Reply from 64.78.193.84: bytes=32 time=73ms TTL=115
Reply from 64.78.193.84: bytes=32 time=46ms TTL=115
Which of the following utilities produced this output?
The output provided appears to be from the "ping" utility.
How is this so?Ping is a network diagnostic tool used to test the connectivity between two network devices,typically using the Internet Control Message Protocol (ICMP).
In this case, the output shows the successful replies received from the IP address 64.78.193.84,along with the response time and time-to-live (TTL) value.
Ping is commonly used to troubleshoot network connectivity issues and measureround-trip times to a specific destination.
Learn more about utilities at:
https://brainly.com/question/30049978
#SPJ1
reference of generation of computers?
Answer:
First Generation: Vacuum Tubes. Second Generation: Transistors. Third Generation: Integrated Circuits. Fourth Generation: Microprocessors. Fifth Generation: Artificial Intelligence
If the old and new systems are operated side by side until the new system has proven itself, this type of system conversion plan is parallel implementation. True or false?
Answer:
True
Explanation:
Which wireless device connects multiple laptops, tablets, phones, and other mobile devices in a corporate environment?
Answer:
Bluetooth or a wifi router or a gateway
Explanation:
Users are unable to open files that are not relevant to their jobs. Users can open and view files but are unable to edit them. Users can open, view, and edit files. The bullet points above describe _____. Responses access privileges firewalls network topologies modems
Answer:
Explanation:
them
BONUS QUESTION WORTH 100!!
no links please and no copying and pasting .I will report you and you will be given a warning.
only answer if you know this please!.
Your Assignment, Part I
You decide that you want to open a flower shop. You want to sell premade arrangements, custom arrangements, bouquets containing either one or two types of flowers, and individual flowers.
Before you can open a shop though, you need to make sure your personal finances are in order. You can use spreadsheets in order to do this.
Submit any spreadsheets you create to your instructor at the end of this project.
1. Imagine you have $15,000 saved in a personal account to help supplement your income during the first year your business is open. Per month, the rent on your current apartment is $500, utilities are generally about $45, gas for your car is about $120, and food costs are about $350. In September, you know your rent will increase to $525 per month. Create a budget that divides the $15,000 across these categories for a full year. If there is any extra money, include that in your budget.
2. With your personal finances taken care of, you feel prepared to open your flower shop. You secure a small business loan for $60,000. You want to spend $30,000 of that loan renovating the space for your shop and $15,000 on equipment needed to store the flowers and create arrangements. Rent will be $700 per month or $4,200 for the first six months the shop is open and utilities will be approximately $76 per month or $456 for the first six months. You also want to spend $2,000 on flowers and supplies to stock the shop for the first month and $600 per month for the next five months to restock flowers and greenery.
a) Create a budget for the shop’s opening with this information.
b) Looking at these numbers in the spreadsheet starts to get a little overwhelming. You want to be able to look quickly at a chart and have a good idea of how much of your loan will be used in the first month of opening the business. What type of graph or chart would work best for this?
c) Create the graph or chart that will best show how you spent your loan in the first month of opening the business.
3. The shop has been open for a week now and you need to work on the first payroll for your two employees, Sean and Justine. Sean’s hourly pay is $8.25. He worked 10 hours this week and is taxed at a 5% rate. Justine’s hourly pay is $9.00. She worked 30 hours this week and is taxed at a 6% rate.
a) Create a spreadsheet for your payroll. Make sure you use a formula to automatically calculate Total Pay.
b) Did you use conditional formatting on any of the cells? If so, which ones? Explain why.
4. After working on payroll, you decide to take inventory of what’s in the shop because your next order date is coming up soon. You will just focus on your inventory of flowers.
a) Use the following information to create your inventory record:
254 red roses currently; 48 sold this week
102 yellow roses currently; 12 sold this week
40 pink hydrangeas currently; 3 sold this week
164 white daisies currently; 52 sold this week
132 yellow daisies currently; 48 sold this week
144 orange daisies currently; 18 sold this week
86 pink lilies currently; 4 sold this week
102 white peonies currently; 24 sold this week
98 pink peonies currently; 36 sold this week
b) If your current rate of sales continues, in how many weeks will you run out of pink peonies and red roses, assuming that all flowers remain fresh? Use your spreadsheet to calculate the answer.
5. Kimberly Melville comes in wanting to order a personalized flower arrangement. She wants an arrangement with 10 white daisies, 4 white peonies, and 2 pink lilies. White daises are $1 each, white peonies are $2.75 each, and pink lilies are $4 each. Kimberly also chooses a vase that costs $14.00. Each of these items is taxable, and the tax rate is 7.5%. You write down her address as 300 Starlight Court, Baltimore MD, 21228. Create an invoice for this order.
6. Three months after the shop first opens, you want to create an up-to-date balance sheet to see how the company is doing financially in its first quarter (January through March). Use the information below to create your balance sheet.
Your current assets include:
$3,546 for Accounts Receivable (from invoices)
$15,000 for Equipment
$3,200 for Inventories
$678 for Cash
Your current liabilities include:
$3,200 for Accounts Payable
$4,200 for Wages
$300 for Taxes Payable
Total expenses for the year: $12,280
The Budget PlanBased on the information provided, here's a budget plan that divides the $15,000 across the categories mentioned:
Rent:
$500 x 8 months = $4,000
$525 x 4 months = $2,100
Total rent expenses = $6,100
Utilities:
$45 x 12 months = $540
Gas:
$120 x 12 months = $1,440
Food:
$350 x 12 months = $4,200
Total expenses for the year: $12,280
With $15,000 in savings, this leaves $2,720 for unexpected expenses, emergencies, or any other miscellaneous costs that may arise throughout the year.
It's always a good idea to have some extra funds available in case of unforeseen circumstances, so this budget plan provides a cushion for those situations.
Read more about budgets here:
https://brainly.com/question/6663636
#SPJ1